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