Create a UserQueryForm

[rkm2]

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.

 

[KeithG]

Search the forum for dynamic SQL. I, along with others have posted several example.