Consistent data updates

P

Proposal Doctor

I use lookup tables with only one defined field to store terms (e.g., names
of time periods, types of insurance, etc.). I then use linked forms to edit
these tables.

When I close the linked forms sometimes the data in the primary form is
immediately updated and sometimes it is not.

What causes this? I create the lookup tables and linked forms in the exact
same way each time and the linked forms always have the same two command
buttons (i.e., Delete Record and Close Form). This occurs in the same
database and with the same master form. I am not using Requery or Refresh
with the linked forms that work properly, so that doesn't seem to be the
problem.

What tells Access to update the data on form close? Is it possible that a
control is doing the bad or is the order in which I add the command buttons
the problem?

Thanks for insight into this problem.

David
Access 2007
 
P

Proposal Doctor

I solved the problem with a RunCommand Refresh statement in the macro.

David
 

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

Top