Split database - Updating tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I split my database yesterday and had to update a table today. I went to the
table dB and added a field. When I went back to the forms, queries, etc
program I do not see the field.

What do I do to get it to see the changes?
 
hi Mark,
I split my database yesterday and had to update a table today. I went to the
table dB and added a field. When I went back to the forms, queries, etc
program I do not see the field.
What do I do to get it to see the changes?
Click to expand...
You need to relink the table.

mfG
--> stefan <--
 
Adding a new column to a table will not automatically add it to queries.
You need to modify every query that needs the additional column. As to
forms and reports, same thing. Controls are not automatically added, you
need to do it. Access has no way of knowing what modifications are required
by the addition of a field. Only you know.

If you have trouble getting a form or report to "see" new columns in a
query, delete the query name from the RecordSource property, save the
form/report, and then paste the query name back in. That makes Access
refresh the fields collection for the form/report so it will see new fields
added to its RecordSource.
 
Back
Top