In a form I have several combo boxes where the user chooses entries from another table. In the form I have also created links to these other tables so that if an entry is missing the user can got directly to the correct table, edit it, and return to the form and complete it.
This all works fine as long as the user has not tried to do anything in the combo box (using drop down or typing any letter). If they have, upon returning to the form the new value is not displayed in the combo box. Updating the form gives an error message that the field cannot contain a null value. And now we are stuck.
What can I do to solve this?
Thanks!
twallstr
Using MS Access 2000
This all works fine as long as the user has not tried to do anything in the combo box (using drop down or typing any letter). If they have, upon returning to the form the new value is not displayed in the combo box. Updating the form gives an error message that the field cannot contain a null value. And now we are stuck.
What can I do to solve this?
Thanks!
twallstr
Using MS Access 2000