Adding to Combo Box Values

[JeepsR4Mud]

How can I set the combobox list to refresh?

I have a macro to open a form to add a new record if the record needed is not in the table/query on which the combo box is based.

However, when I close the form used to add the new record, the new information is not in the combo box in the original form.

Thanks.

Gayle Ann

 

[dcx693]

In the close event of the form you're using to add a new record, you need to requery the combo box on the "original" form using a VBA statement like this:
Forms!myform!combobox.Requery

 

[JeepsR4Mud]

I keep getting an error that I have to save the field before the requery. I must be putting the docmd.save command in, but must be putting it in the wrong place.

Gayle Ann

 

[dcx693]

This article might help you: Add item to combo box using OnNotinList event .