Combo Box

J

Jennie

I have two different forms in my database that have a combo box used to
select report criteria. I don't know what I am doing wrong, but every once in
a while, the combo box stops working properly, when I click on the drop down
arrow, none of the records are listed and a dialog box pops up asking for the
value to be entered manually. What am I doing wrong?
 
G

Graham R Seach

Jennie,

It sounds like the combo's query can't find a field or criterion. If it's
using a form field in the criteria, wrap the criterion in the Nz() function,
so a value will always be supplied. For example:
SELECT Nz([FieldA], 0) FROM Table1

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top