Updates to table fields not updating in form

  • Thread starter Thread starter Marni
  • Start date Start date
M

Marni

I am creating a form that pulls fields from a query.
Whenever I make a change to the tables that the query is
pulling from, the changes pass on to the query, but stop
there. For example, I have a combo box on my form that
originally contained the values 1-5. I added 0 to the
field in the table. When I go to the query, 0 appears in
the combo box. However, I cannot get my form to also
update.

Thoughts?
 
That is correct. You can either...

Delete the field from your form and then re-add it. The new options should
be there.

or

Simply go to the field properties in the form design and add the option
there as well.

The settings in the table are simply the defaults used when you add that
field to a form, report, etc. If the user overrides them on a particular
form, you don't want a change to the table to affect the form.


Rick B


I am creating a form that pulls fields from a query.
Whenever I make a change to the tables that the query is
pulling from, the changes pass on to the query, but stop
there. For example, I have a combo box on my form that
originally contained the values 1-5. I added 0 to the
field in the table. When I go to the query, 0 appears in
the combo box. However, I cannot get my form to also
update.

Thoughts?
 
Back
Top