combo box

[twallstr]

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

 

[RuralGuy]

Put a Me.cboName.Requery in the GotFocus event of the cbo - using your cboName of course.

 

[twallstr]

RuralGuy.

Your suggestion worked just fine. I just have no idea what I did. Any suggestion where this is explained?

Thanks!

twallstr

 

[RuralGuy]

You told the ComboBox to completely reload it's RowSource every time the user enters the ComboBox which will pick up any new records. Did that make sense or would you like some links to Access tutorial sites?

 

[twallstr]

RuralGuy!
Thanks for the explanation. Now I understand

twallstr

 

[RuralGuy]

You're more than welcome. Continued success with your project.