On Not in List

[Eddie Mason]

Hi all,

I've got a combo-box reading from a table, on a data-entry form for a report. On which, I'm using the On Not In List Event to allow the end user the opportunity of entering an additional record whilst remaining in the data-entry form.

this works perfectly well but new entry does not appear in the combo-box list unless the data-entry form is closed and re-opened.

Can anyone help with this?

Regards

Eddie

 

[maxmangion]

you need to requery your combo box

 

[Eddie Mason]

many thanks for your help.

Regards

Eddie

 

[maxmangion]

you're welcome