Apply multiple filters based on custom filter form [macro?]

Hello.

While I'm confident in my abilities in Excel, I'm pretty inexperienced with Access. However, I have a project which requires the use of an Access DB and I have most of it finished except one portion.

What I am trying to do is create a Filter form. The filter form is currently not connected to any tables as I don't want the data editable from the form itself; it just has a few textboxes/comboboxes and a button (Apply Filters). It opens in Windowed mode.
When the form is opened, I have a macro opens up a second form. This second form is a datasheet view of the data I wish to filter by, and also where the data is to be modified from.

Basically what I want to do is be able to select various criteria on the Filter form, hit apply, and have those filters apply to the datasheet, allowing for easier editing of the data.

I can't find anything on how this might be achieved, and considering it seems like a pretty standard requirement for Access I'm also assuming there is probably a much better easier way to do this that I just haven't stumbled across yet that is built right into access. None of the users of this database have any experience in access or databases - so the 'Filter by Form' option built into Access probably won't work for them, it's too different from what they are used to. A popup filter window with a datasheet for entry is much more intuitive and something they are used to.

...anyone have any insights?


Thanks!