Refresh Form

[mixedguy]

Need help!

I've built a form where the users can double click on a selected record to link the record from one database to another record in a different database. If the user doesn't see the record he/she needs, they can add the record by clicking on the "Add New Requirements" button.

My issue is when they add the new record I want the Requirement Picklist form to refresh reflecting the new record. Preferably in the form "New Requirement - Document Log" when the user clicks the Save Button I want it to save my new record and update/refresh my "Requirement PickList" form.

Here's my current code on the save button.

Private Sub Command20_Click()

DoCmd.RunCommand acCmdSaveRecord
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryReqNo_Update", acViewNormal, acEdit
DoCmd.Close

End Sub

Any help will be very thank ful
Todd

 

[Mile-O]

Use Me.Refresh to update your form.

Also, in your code - if you are turning the Warnings Off, be sure to turn them back on again within the same procedure.

 

[mixedguy]

Me!Refresh...

I put the Me!Refresh in the Requirement Pick List Form in the event procedure "On Got Focus." The "New Requirement Document Log" form is a pop up form which allows the users to add a new requirement. That didn't work.

is there somehow I can put the a refresh code in the save button of the form "New Requirement Document Log" form that says something like.

Docmd.refresh "RequirementPickList"

Plz Advise.
Thanks!
Todd