fudge (1 Viewer)

[mission2java_78]

ok...
Can someone help with this:
"SELECT tblRecords.RecordID, tblRecords.SOID FROM tblRecords WHERE tblRecords.SOID Like *" & txtBeenUsed & "* ORDER BY tblRecords.SOID"

txtBeenUsed is a string
not on a form but a variable ...

Jon

 

[Jack Cowley]

Try:

"SELECT tblRecords.RecordID, tblRecords.SOID FROM tblRecords WHERE tblRecords.SOID Like "*" & txtBeenUsed & "*" ORDER BY tblRecords.SOID"

hth,
Jack