Linked Fields not Updating

  • Thread starter Thread starter lovespar
  • Start date Start date
L

lovespar

I have a Macro attached to the start up of a FE Database. It runs a query
that updates a table with one date- That date is linked to all the other
tables in the DB.
You can't fill out the forms unless that date is filled in.
For some reason the tables won't pull in the date. The Macro and query ran.
The date was correct in the date table, but blank on the other tables.
I added it in by hand but am wonmdering how to fix this problem
Thanks in advance
 
I'm unclear what you mean by "that dates is linked to all the other tables in
the db." How are you doing the linking? It sounds to me like you need to run
a separate query for each table to update the date.
 
That would make sense to me too, however this DB has been operating for 2
years without it. When I say linked, I mean in the Table link manager. Is
there any other way to get the date into the tables than seperate queries. I
am missing something here somewhere.
 
For some reason the tables won't pull in the date. The Macro and query ran.
The date was correct in the date table, but blank on the other tables.
Click to expand...

If you're expecting a query which updates one table to automagically update a
whole bunch of other tables at the same time, you're on the wrong track: it
won't.

What code or query or form operation enforces "You can't fill out the forms
unless that date is filled in"?
 
The form is automatically updated with the new date on Startup. Macro to
Form, then a query updates the date in a Monthend Table. That table is linked
to the other 9 tables in the linked table manager.
 
The form is automatically updated with the new date on Startup. Macro to
Form, then a query updates the date in a Monthend Table. That table is linked
to the other 9 tables in the linked table manager.
Click to expand...

Well, then fix the error in the macro or the code.

If you would like help doing so please post some information about them. We
can't see your screen!
 
Back
Top