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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
Access Form - Lock Fields from Editing 0
calculated field in form - to table 2
Update Form 1
Two Form Fields Reference The Same Table Field 3
Access 2003 file in Access 2007: Simple form control 1
update data in one table using form 3
Table update using combo box. 3

Back
Top