using combo box to query a table

  • Thread starter Thread starter Lindsay
  • Start date Start date
L

Lindsay

I am using 1 combo box with its source as a table. When
the combo box is selected, the table is queried and a
report is printed. The problem is that every time I
select an item from the combo box, the source table is
changed. It will delete the first record in the table and
change it to whatever item was selected from the combo
box. Any suggestions will help...
 
I am using 1 combo box with its source as a table. When
the combo box is selected, the table is queried and a
report is printed. The problem is that every time I
select an item from the combo box, the source table is
changed. It will delete the first record in the table and
change it to whatever item was selected from the combo
box. Any suggestions will help...
Click to expand...

Use an Unbound combo box for this purpose; set its Control Source
property to blank.
 
Back
Top