Update to a form field from the database

[Sam B.]

Hello all, I think this is a pretty simple question, I must be missing
something. I created a simple database and I made one of the fields a Lookup
Wizard field and added a couple items. I then created a form based on the
fields in the database.

I needed to add another item to the list I created, but it did not populate
the field in the form (drop down box). How can I make it so the field in the
form will automatically update if I add a nother item to the list?

Thank you in advance

 

[Pat Hartman]

The best solution is to create a separate table that contains your value
list. Lookups should NOT be defined at the table level since they cause
numerous problems with queries and code. The lookup on the form should use
a query of the new value table as its RowSource.

 

[Sam B.]

OK, so my field list was of Cell Phone Manufacturers. You're saying that I
should create a separate table titled "CellPhoneManufacturers" and link it to
the main table using a field in the main database "CellPhoneManufacturersID"?

 

[Pat Hartman]

You need to use the CellPhoneManufacturers table as the RowSource for the
combo box. If you want to restrict the contents of the bound field to only
values from the RowSource, set the limit to list property to true. you
should also define a relationship between your main table and the lookup
table in the relationships window and check the enforce RI box.