Recordset

[marrett]

Hi
I Need to get the following statement to work.


Set RST = db.OpenRecordset("Select * From [users]where [user]=" & Forms!usersignin!User)

User in users is text. Please help.

 

[Everton]

For string criteria you need to put the data in single quotes. Try:

Set RST = db.OpenRecordset("Select * From [users]where [user]= '" & Forms!usersignin!User & "'")

Hope this works,
Paul

 

[marrett]

Thanks Paul,

I Still cannot get it to work.

I used your s and I get the error> Method 'Item' of Object 'Forms' Failed

Set RST = db.OpenRecordset("Select * From [users]where [user]= '" & Forms!usersignin!User & "'")

Please help.

Thnaks,

Maria

 

[HiArt]

Is this as simple as

Set RST = db.OpenRecordset("Select * From [users]where [user]= '" & Forms!usersignin!User.Value & "'")

??? or caption ???

Art

 

[Jon Holmes]

In all the examples no-one has placed a space before "WHERE" to separate it from the recordsource [users].