Wherecondition with input parameters

[luker74]

Hello,
i would like to implement a wherecondition with two input parameter as conditions, my code is:

DoCmd.OpenForm "Cognome_status", acNormal, , wherecondition:="[surname] = " & InputBox("Surname") & " and [status] = " & InputBox("Status")


when i run this code it ask me two times the surname and two times the status, anyone can tell me why?

thanks

 

[PHV]

A starting point:

Dim strSurname As String, strStatus As String
strSurname = InputBox("Surname")
strStatus = InputBox("Status")
DoCmd.OpenForm "Cognome_status", acNormal, , "surname='" & strSurname & "' AND status='" & strStatus & "'"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886