Hi John,
Personally, I have found the built-in Query by Form (QBF) in Access to be
rather confusing, especially for users that you may need to support. I have
some QBF samples available that you might want to have a look at:
http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip
If you are okay with using some Visual Basic for Applications (VBA) code,
the samples get even better:
http://www.accessmvp.com/TWickerath/downloads/elements.zip
http://www.accessmvp.com/TWickerath/downloads/Chap08QBF.zip
The first one shown above, Elements.zip, is about as easy as they get. Here,
I have shown just a single multi-select list box control, to allow one to
select one or more elements from the periodic table in the list. Hey, I'm a
chemist, so this example was natural for me! Anyway, you can make a
continuous selection by holding down the Shift key, or a discontinuous
selection by using the Control key.
The Chap08QBF sample is the basis for all of my QBF forms. This sample came
from Scott Barker's book titled "Access 2000 Power Programming". It includes
the original form/subform, as well as my modifications to these two forms.
If you'd like to learn how these work, I have a Word document and sample
Access database available here:
http://www.seattleaccess.org/downloads.htm
Look for:
Query By Form - Multi Select
Tom Wickerath, February 12, 2008
If you are new to VBA code, then your first stop should be to check out
these two documents:
http://www.seattleaccess.org/downloads.htm
DAO - Back To Basics Compilation/Demo
by Tom Wickerath, Jan/Feb 2007
and
Access Basics by Crystal
http://www.accessmvp.com/Strive4Peace/Index.htm
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
