 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Refresh after New Record Added
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  SignatureA MACKENZIE, CMA, MBA >I have created an input form for new records from our main production form. > [quoted text clipped - 5 lines] > > 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 SignatureBrendan Reynolds Refresh did not work Requery did. Thanks SignatureA MACKENZIE, CMA, MBA > >I have created an input form for new records from our main production form. > > [quoted text clipped - 15 lines] > > 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 SignatureA MACKENZIE, CMA, MBA > Refresh did not work > [quoted text clipped - 21 lines] > > > > Forms("NameOfMainFormHere").Requery Where did you put the requery in the form properties? > Tiurns out that the "requery" command only works when the form is opened > directly from the Forms menu. [quoted text clipped - 41 lines] >> > >> > Forms("NameOfMainFormHere").Requery 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. SignatureA MACKENZIE, CMA, MBA > Where did you put the requery in the form properties? > > Tiurns out that the "requery" command only works when the form is opened [quoted text clipped - 42 lines] > >> > > >> > Forms("NameOfMainFormHere").Requery |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.