Refreshing combo box when item not in list

[mulligh]

Refreshing combo box when item not in list and you've just created a new list entry.

OK, I've got a combo box and an entry must be chosen from the list. If the item entered is not in the list, then a data entry form opens so they can add it. Now when they close this data entry form, I want the combo box to refresh, so that when they press the TAB key (with the new item that should now be in the list), I want it to recognize it in the combo box list. How do I do this? Thanks.

 

[HenryAnthony]

Hi,

I have used a macro to do this with a combo box based on a query. Set the on enter property of the combo box to a macro that runs the action: requery, control name: comboboxname.

Best regards,

Henr¥