M
mattc66 via AccessMonster.com
I have the following code.
When the DoCmd.Close runs it opens a form. However it opens the form based on
the stLink. That was form the DoCmd before that one. How do I set the syntax
so that it opens the form and shows all the records?
stLink = "[OrderNum]=" & "'" & Me![OrderNum] & "'"
stDocName = "sfrmShipLabelPrompt_C1"
DoCmd.OpenForm stDocName, , , stLink
DoCmd.Close acForm, "frmShipMain_C1", acSaveYes
When the DoCmd.Close runs it opens a form. However it opens the form based on
the stLink. That was form the DoCmd before that one. How do I set the syntax
so that it opens the form and shows all the records?
stLink = "[OrderNum]=" & "'" & Me![OrderNum] & "'"
stDocName = "sfrmShipLabelPrompt_C1"
DoCmd.OpenForm stDocName, , , stLink
DoCmd.Close acForm, "frmShipMain_C1", acSaveYes