Parameter query

[eussias]

I'm trying to open a recordset using a specific parameter query, and for some reason (simple I'm sure) it's not opening. Saying there are too few parameters. Below is the line of code I'm trying to use...

Set rst = CurrentDb.OpenRecordset("SELECT * FROM UserList WHERE [UserName] = " & txtUserName.Text & "&quot

txtUserName is a text box where the user enters their user name. Can anyone see what I'm doing wrong here??

 

[Craig0201]

Set rst = CurrentDb.OpenRecordset("SELECT * FROM UserList WHERE [UserName] = '" & txtUserName.Text & "'&quot

Craig