General information
Category:
Forms & Form designer
Title:
Combo box and blank entry
Hi everyone:
I have been having problems with a form and combo box. I want to give users the chance to select an empty value, but I can't seem to make it work. The combo box is selecting the values from a table using row source #3 (sql). If i add an empty value in the table and give it an id value of 0 (ie to make it the first value in the combo box if the sql statement is ordered by id value), it screws up the value that gets sent to the table in the "save" button in the form. It is always off by 1.
I hope this makes sense to somebody and that they can help me. If you have any questions or if I can do a better job of explaining it, please request clarification. Thank you.
Paul
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only