Creating a dynamic query def

[DHSBW]

I'm getting a runtime error 3061: "Too few parameters" when I try to create a dynamic query def based on two parameters. Thanks for your help in advance.


S1 = "Select [User Name],[Password], [Administrator] from [User Accounts] WHERE (([User Name]= [Forms]![Login]!UID) And ([Password] = [Forms]![Login]!PW))

Set Def1 = Data1.CreateQueryDef("UserScreen", S1)

 

[Ed2020]

Try:

S1 = "Select [User Name],[Password], [Administrator] from [User Accounts] WHERE (([User Name]=" & """" & [Forms]![Login]!UID & """" & ") And ([Password] = " & """" & [Forms]![Login]!PW & """" & "))

UID and PW are text strings so need a text qualifier around them.

Ed Metcalfe.

Please do not feed the trolls.....

 

[DHSBW]

Got it. Thanks.