Advanced filter form

[akingsley]

Hi -



I am trying to create an advanced filtering form for a membership database I designed. I am just having trouble wrapping my head around how to do it. Any help would be greatly appreciated.
This is basically what i want it to look like:




Thanks in advance!

Allison

[weekend00]

I can't figure out what do you need, what did you get and what's your problem?

[akingsley]

I'm try to recreate the form I posted above which is from another database program.

I'm fairly familiar with access but have not had much of a chance to do too much code other than some real simple basic stuff.

I guess that I really need to know is how to tell that combo box with and, or, less than, more than, etc how to function and then how to get the fields to work together.

[slave138]

It sounds like you're trying to recreate the built-in Query Builder - it can be done but will likely require some pretty involved coding. I would suggest doing a few searches on using SQL statements from VBA. That way you can build the SQL string based on the selections in the form and then execute the constructed string.

[akingsley]

I'll check that out. Thanks!