Help! Need to display new records in a look-up field on a form.

[FatMan]

I hope someone out there can help me.

On my form is a field that is bound to a table and retrieves the value
(CustomerNo) through a look-up. By clikcing on a command button the user can
go to the customer table and add new records "on-the-fly". What I would like
to do is to show the user the new records added to the Customer's table when
they return to the original form. To make things clear the "look-up" is
looking up the values in the customer's table (linked) and not a list that
has been typed in.

I have looked in the help files and my resource books but can not find
anything the nearest I can come is the "refresh" method/property, but this
will not display new records.

Is there a Guru out there than can help.

Thanks,
FatMan

 

[Marshall Barton]

On my form is a field that is bound to a table and retrieves the value
(CustomerNo) through a look-up. By clikcing on a command button the user can
go to the customer table and add new records "on-the-fly". What I would like
to do is to show the user the new records added to the Customer's table when
they return to the original form. To make things clear the "look-up" is
looking up the values in the customer's table (linked) and not a list that
has been typed in.

You need to REQUERY the combo or list box after the customer
form is closed. If you open the customer form in Dialog
mode, you can just use code like:

DoCmd.OpenForm "customerform", _
WindowMode:= acDialog
combobox.Requery