Updating combo box

[Guest]

Hi there,
this is probably something simple but ... I created a table with a few
lookup fields to make data entry easier on the form. The amount of
information is fairly small so I didn't want to use another table to lookup
the data. Thus, I created a value list and put in the data. Then I used the
wizard to create the form for data entry. Later I realized that one of my
lists had some missing possibilities. I went into the design view of the
table and changed the value list. However, those changes are not reflected in
the form. Sometimes it seems like this works and sometimes it doesn't. Can
anyone tell me if this does work or what I should do to get the table to
update the form. The field in the form is "bound" to the column in the table.
Thanks!

 

[Guest]

Hi

1st of all don't use the table fields to lookup another table for lots of
eason (there are many posted on this forum).

Next. You can simply format the field to accept text, number or whatever
and then set the rows for the combo on the form itself. This information
will still save to your table records.

Like this

You have a field in your table called Names
Open the form in design view and view the field list
Drag the field Names on to your form.
At the moment it will be text box.
Select Format menu and then ChangeTo
Select Combo Box
Row Source Type can be a value list
Row Source eg. "John","Mary","Jill"

After you select a name from the list and set focus to another control it
will save the name to the table field