updating the combo box query when it is clicked

[AndyRob1973]

Hello,

I have a form with a combo box whose contents are a unique list of people in a table (let's all it tblPeople). I use a query to obtain this list.

On this form I have a button which takes you to another form which allows you to input into tblPeople.

When I go back to the original form ad click on the combo box, I cannot see the new entry. I have to close it down and reopen.

Could someone point me in the right direction. I have tried an on click event of DoCmd.requery but this doesn't seem to wok.



Thanks,

Andy

[Bob Fitz]

Try:

Me.NameOfComboBox.Requery

in the Got Focus event of the combo box

Substiute NameOfComboBox with the name of your Combo box

[Micron]

Or requery the combo in the close event of the input form rather than every time it gets the focus, which disregards whether or not a value was just added to the list.

[orange]

I agree with the other responders. However, you may get some additional insight from this video by Richard Rost on Edit Combo List Item.

[AndyRob1973]

Thank you all.

I have gone down the Got Focus route and that seems to work.

However, just so I understand, if I wanted to requery when closing the input form, would it be:

InputFormName.ComboBox.Requery ?

because the combobox is on a different form than the input form

[Micron]

Forms!InputFormName.ComboBox.Requery

The form would have to be open but could be invisible.