Delay in control fields in 2 forms being in updated (not in sync)

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

Guest

I have 2 forms with the same control field. If I change the control field in
one form, there seems to be a delay in the other form being updated. For
example, I have code that stores a value in Forms!FORM1!field1. (If I look at
the associated table, field1 has been updated successfully.) But, if I look
at FORM2, the field1 has not been updated. However, if I open/close FORM2
several times, the field1 is eventually updated.
Is there a way that I can force the control field in FORM2 to be updated
immediately after the control field is changed in FORM1?
 
Jsccorps,

Do you mean that you have both forms displayed at the same time? This
is unusual! First, you would need to save the change to the table, and
then requery FORM2. On the AfterUpdate event of the control on FORM1
would probably be applicable. Code something like this...
DoCmd.RunCommand acCmdSaveRecord
Forms!FORM2.Requery
 
Back
Top