Create a UserQueryForm

[Guest]

I am trying to create a UserQueryForm which allows a user to:

• Select values from several fields of criteria;
• Select multiple values within each field;
• Create a report based on the selected criteria.

My database is a membership database created in Access 2007. It is linked
to a database which contains several tables, linked by a unique MemberID,
including:

• MemberMasterTable (Includes members Names, Gender, Age, Chapter, etc)
• MemberAddressTable (Includes members Address, City, State, etc)
• MemberPartyAffiliationTable (Includes members voter RegistrationDate and
PartyAffiliation)
• MemberDistrictTable (Includes members DistrictNumber and DistrictType

Additionally, I have a ListForm that is generated by a RunListFormMacro on
the PoliticalPeopleForm which allows users to open the ListForm based on the
values in the DistrictNumber and DistrictType fields of the current record on
the PoliticalPeopleForm. I would like to place a similar macro on the
UserQueryForm which would open the ListForm based on the multiple criteria
selected on the UserQueryForm.

I have previously tried using a combination of QueryByForm (QBF) and
Multiple Value Lookup Fields, but I have only managed to completely confuse
myself.

Any help with the best way to go about this would be greatly appreciated.

 

[Ken Snell \(MVP\)]

See my sample database here:
http://www.accessmvp.com/KDSnell/SampleDBs.htm#FilterForm

It shows how to use various controls for selecting criteria for a query that
is then used as a report's RecordSource.