General Form & Query VB question
Posted on 2004-04-13
I have a form that when the user selects data from comboboxes and hits submit
it runs a query and opens the data in another form
the first Combobox(ComboFormat2 see code below) in the form determines the values available in the secondcombobox
however, this only allows me to search for one record at a time
i have tried to put a subform in the form that has a row source
SELECT SiteInformation.SiteID, SiteInformation.SiteLocation, SiteInformation.Blocked, SiteInformation.SiteType, SiteInformation.Prismatic, SiteInformation.Illuminated FROM SiteInformation WHERE SiteInformation.SiteType=Forms!Form2!ComboFormat2;
and it works in displaying the values, the question I would like to be able to highlight or select several records from this subform
and on submit send them as parameters of the query as opposed to just one record
is this possible????
i can send all the code i have so far if needed!