Unwanted prompt for parameter when opening form 1

[annsolomon]

I want to prompt the user for a purchase order number (using an inputbox) then open the form for that specific purchase order. My inputbox works and the correct purchase order is opened but I get a second prompt for the parameter FindPO.

How can I set the Where clause of DoCmd.OpenForm to use the value for FindPO that the user entered in the inputbox?

Dim FindPO As String

FindPO = InputBox("Enter the PO #", "Bionetics PO System&quot
DoCmd.OpenForm "frmPO", , , "PONumber=FindPO"


Ann

 

[AccessAce]

FindPO = InputBox("Enter the PO #", "Bionetics PO System&quot
DoCmd.OpenForm "frmPO", , , "PONumber=FindPO"

Should be
FindPO = InputBox("Enter the PO #", "Bionetics PO System&quot
DoCmd.OpenForm "frmPO", , , "PONumber='" & FindPO & "'"

 

[annsolomon]

Ace, you're an angel for giving me the help I needed so quickly. Of course, it works perfectly now. I still get confused about those darned single and double quotes.

Ann