how do I save changes made in table so they appear in form view

[Seth Schwarm]

Can you explain in a little more detail how your tables
and form are setup?

Seth Schwarm

-----Original Message-----
I am attempting to make changes in a table so that when

entering new data the changes occur in form view. I have
saved the changes, and when I open up the specific table,
the changes are there. However, when I open up the form
that we use to enter data, the old categories are still
there, unchanged. What can I do to troubleshoot this?
The database in question is on the network for our
office. THank you.

 

[Megan]

Sure. Our tables are set up as follows
client
Job Order
Category
Nam
Dat
Etc

All of these tables have the correct drop-down menus available so that when we pull up the form to enter in job orders, we can choose the date or category, for example. The category table entries were just changed, and although they appear to be saved when I open up just that table, they are not saved in the actual drop-down menu of the form. Does that make sense? Let me know if you need more info

 

[Immanuel Sibero]

Hi Megan,

Not too clear, but I'm guessing you're asking about the records in the
tables used as look up values for your drop down box?
If so, you would need to requery the recordsource of the drop down box
everytime there is a change in the table used as a recordsource.

HTH,
Immanuel Sibero

Sure. Our tables are set up as follows:
client #
Job Order#
Category#
Name
Date
Etc.

All of these tables have the correct drop-down menus available so that

when we pull up the form to enter in job orders, we can choose the date or
category, for example. The category table entries were just changed, and
although they appear to be saved when I open up just that table, they are
not saved in the actual drop-down menu of the form. Does that make sense?
Let me know if you need more info

 

[Seth Schwarm]

Megan:

When you say you entered new values in a table, do you
mean you entered the values in table view. You know, the
view where you can see every record in the table that
your screen will allow. Or, did you enter these new
values into a Value List in the design view of the
table? Then you flipped into table view and clicked the
drop down arrow on your combo box and saw all your new
values?

I am assuming you have a combo box showing on your form
that is displaying the categories you can choose from.
Is this correct? If so, what is the Row Source for this
field in design view of your form? Is it the table you
entered the new values into? Is it a query, and if so,
what table(s) is it based on? Or is it a value list?

If it is a value list, this is the way Access works.
When you create a value list in table design view, then
create a form on that table, Access copies the settings
of the field you made in table design view to the new
field on your form. If you went back to your table and
edited your value list, it will not be updated in the
field on the form. You will also have to edit the value
list in the form's design view of this category field.
If this is what you have done, don't waste time editing
the value list in the table anymore; only edit the value
list in the form's design view for the Category field.

Fortunately and unfortunately Access does not link the
two fields to each other (the one in the table and the
one on the form).

Let me know if we are running down the right trail.


Seth

-----Original Message-----
Sure. Our tables are set up as follows:
client #
Job Order#
Category#
Name
Date
Etc.

All of these tables have the correct drop-down menus

available so that when we pull up the form to enter in
job orders, we can choose the date or category, for
example. The category table entries were just changed,
and although they appear to be saved when I open up just
that table, they are not saved in the actual drop-down
menu of the form. Does that make sense? Let me know if
you need more info