ComboBox Help

[Joe Wojcik]

I have prepared a form from a query where I have selected certain information
available from the query. In the form preparation I have not included the
"ID" tag as it will show all records - over 9000 and by selected the small
number or column information and running some calculations in the query I get
the results I need in the form, however, when I add the "ComboBox" it will
show all of the records but only display the first record's information. If
I add the "ID" then I get all 9000 records and not the results I need. I
need the combobox to display all of the records as they are chosen an not
only the first one in the list

Can someone help?

 

[mscertified]

I'm confused by your question. Are you asking about the contents of a form or
a combo box. The contents of the form are determined by the RecordSource, the
contents of the combo box by the RowSource. They are completely unrelated.
Adding a conmbo box cannot affect the forms RecordSource.

Dorian.