Please help a stupid person!

[Ali Edwards]

Should be simple...

I have a combo box in a subform whose row source is a query. The query is based on tblEngineers. The combo box's control source is based on a different table.

I simply want to be able to type a new name in the combo box and have it appear in the list so that when it I go to the next record I can select it from the list.

Currently this only happens if I close the form and reopen it - then it appears in the list.

I have tried the following on the after update of the combo box:

me.requery
form.requery

to no avail.

What am I not doing?

Thanks!
Ali

 

[dcx693]

You're not a stupid person, you just have to requery the combo box.
Me.combobox.Requery

 

[Ali Edwards]

Thanks DC!