Refresh after New Record Added

  • Thread starter Thread starter aMack
  • Start date Start date
A

aMack

I have created an input form for new records from our main production form.

The main form does not refresh after the new record is added.

I have to exit and reopen to see the new record.

Where can I pout a Refresh command to show the new record immediately?

Thanks
 
aMack said:
I have created an input form for new records from our main production form.

The main form does not refresh after the new record is added.

I have to exit and reopen to see the new record.

Where can I pout a Refresh command to show the new record immediately?

Thanks
Click to expand...


I haven't tested this, but from memory I believe something like the
following should work, in the AfterUpdate event procedure of the input form
....

Forms("NameOfMainFormHere").Refresh

.... or perhaps ...

Forms("NameOfMainFormHere").Requery
 
Tiurns out that the "requery" command only works when the form is opened
directly from the Forms menu.

When initiated from our "Main Switchboard" it does not.

1) From Main Switchboard - Open Form "Intermodal Transload"
2) From form "Intermodal Transload" initaite macro "Add New Order" - This
adds a new REF# to the data table Intermodal Transload and opens a form "Add
New Order"
3) Close form "Add New Order" with "On Close" command:
Forms(Intermodal_Transload).Requery


What should I look for to troubleshoot this issue?

Thanks
 
The "Requery" command is "On Close" and reads:

Forms(Intermodal_Transload).Requery

It works when the form is opened from the Forms menu but not when opened
from the Main Switchboard.
 
Back
Top