using combo box to query a table

[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...

 

[John Vinson]

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...

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