Changed lookup in a table, need to update form?

[Lea]

I have added an option to a lookup field in a table and need to update the
field options on the related form so that when entering data I can select the
right option. I've done this before but now cannot locate anywhere in the
help section that reminds me how to do it!

Using MS Access 2003

 

[Tom Wickerath]

Hi Lea,

The lookup on your form is likely a combo box that is based either on a
value list, or a table/query. Open the form in design view. Click on
View>Properties to display the properties dialog (if it is not already
displayed). Select the combo box in question. You should see the name of the
combo box in the blue title bar of the properties dialog. Select the Data
tab. Examine the Row Source property.

As for lookups defined at the table level, my suggestion is to eliminate
them. See the 2nd Commandment of Access, here:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________