Globally updating tables

  • Thread starter Thread starter John Hipskind
  • Start date Start date
J

John Hipskind

I am using an "Initialize" form to feed field values to
all of my DB's tables using DLookUp in the Default Value
property in each of my table's respective forms.
For example, a project number appears in all of my
tables, whose value comes from the Initialize form
(actually, its corresponding table.)

If a project number should change, I would like to "re-
initialize" the DB. As now set up, only subsequent values
are changed, but not records previously entered.

Is there a way to update not only the new, but the
existing records as well, with the new project number? I
would like to stay as close as possible to my current
methodology.

Thanks for your help.

John
 
To run an update throughout the table you would normally use an Update Query. Depending on
what is changing about the value, it may or may not be difficult to figure out a formula
for the change in order to tell the Update Query what the new value should look like.
 
Back
Top