Refresh after New Record Added

[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

 

[Brendan Reynolds]

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

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

 

[aMack]

Refresh did not work

Requery did.

Thanks

 

[aMack]

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

 

[Pete D.]

Where did you put the requery in the form properties?

 

[aMack]

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.