pop up will not requery

D

deb

I have a form called f9ProjectMaster that updates and adds new records to the
tProject table. On this form is a button used to find records called list9b
with the below code.
Dim stDocName As String
Dim stLinkCriteria As String

If Forms!f9ProjectMaster.Dirty Then
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
' Me.Dirty = True
Forms!f9ProjectMasterSub.Requery
Me.Refresh
End If

stDocName = "f9ProjGoTo"
DoCmd.OpenForm stDocName, , , stLinkCriteria

This brings up a pop up that the user selects the project to find and
display the record in the f9ProjectMaster form. The pop up has the below
code..
Forms!f9ProjectMasterSub.Requery
Me.Requery


Dim rst As DAO.Recordset

' Store the recordset for the form.
Set rst = Forms!f9ProjectMasterSub.RecordsetClone

' Locate the record for the selected.

rst.FindFirst "ProjMasterID = " & List9b

' Set the form's Bookmark property to move to the record.
Forms!f9ProjectMasterSub.Bookmark = rst.Bookmark

' Close the dialog box.
DoCmd.Close acForm, "f9ProjGoTo"

When create a new record or update a record. the pop up form does not
display the changes unless I close the f9ProjectMaster form and reopen. I
have tried to requery everything but no luck.
I opened the table before I click the button to make sure the changed data
is in the table and it was, but the pop up query only shows the old data.
I'm confused.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top