cRODEEkrank
Technical User
Currently I have a form where users enter appropriate information in the fields. When they're finished, they can click a command button which will open a payment request form with some of the same data on the form. I have the following code to apply a filter:
'Refresh records:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acRefresh, ,
acMenuVer70
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmTestingEmailAgain"
stLinkCriteria = "[Contract ID]=" & Me![txtContractID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
When the "frmTestingEmailAgain" form opens, the records aren't displaying. This form is attached to the table containing all the information from the previous form and all the controls on the form are bound to the fields of the table. The strange thing is, when frmTestingEmailAgain is open but in design view, then opened by the preceding form, all the data shows correctly. Is there something I'm missing?
'Refresh records:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acRefresh, ,
acMenuVer70
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmTestingEmailAgain"
stLinkCriteria = "[Contract ID]=" & Me![txtContractID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
When the "frmTestingEmailAgain" form opens, the records aren't displaying. This form is attached to the table containing all the information from the previous form and all the controls on the form are bound to the fields of the table. The strange thing is, when frmTestingEmailAgain is open but in design view, then opened by the preceding form, all the data shows correctly. Is there something I'm missing?
