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?
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?