How open forms using certain criteria
I have a command button on a form which when clicked I want to have a second form open to display only certain records. Here is my code which is not working.
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmPrintOrdTranx"
DoCmd.OpenForm stDocName, acNormal, , [Type] = "P", acFormEdit, acWindowNormal
Can some please help?
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmPrintOrdTranx"
DoCmd.OpenForm stDocName, acNormal, , [Type] = "P", acFormEdit, acWindowNormal
Can some please help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try this
DoCmd.OpenForm stDocName, acNormal, , "[Type] = 'P'", acFormEdit, acWindowNormal