Here is my issue. I have created a form called “Search” that has several
unbound combo boxes, one for each of the attribute that match a column
in the Table [Movie Titles]. Each combo box has input from a separate
table that limits what the uses can select. IE. The Genre table feeds a
list of options for the Genre combo box.
My goal is to have the user select the attributes they want to use as
search criteria and then feed those selections from the combo boxes into
the query that is executed when you select the “Query” button action on
the form. The results could then either go to a subform within the main
Search form or a separate datasheet view that is generated based on the
Query results. How are fields that are left blank handled? If you can or
are willing to assist then please let me know. I can send a zip version
of the Access 2003 DB if you are able to assist.
Table Name = Movie Titles
TitleID
Title
Genre
Sub-Genre
Media
Etc… Several other attributes for each title.
Form for Query = Search
cbo_Title à gets Title from [Movie Titles] Table
cbo_Genre à gets Genre from Genre Table
cbo_Media à gets Media from Media Table
*** Sent via Developersdex
http://www.developersdex.com ***