SteveL13
asked on
Find a record when the key field is a text field
How can I correct this to work when the key field, TextMnumber, is a text field...
RS.FindFirst "[TextMnumber] = " & Str(Nz(Me![cboFindRecord], 0))
RS.FindFirst "[TextMnumber] = " & Str(Nz(Me![cboFindRecord],
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Steve,
You seem to be struggling a bit with passing strings in code. With that, you might want to read through this:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_12-Dlookup-and-the-Domain-Functions.html
A large part of that article covers the passing of strings within a string (which you often do in code).
Might help clear some things up for you.
Jim.
You seem to be struggling a bit with passing strings in code. With that, you might want to read through this:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_12-Dlookup-and-the-Domain-Functions.html
A large part of that article covers the passing of strings within a string (which you often do in code).
Might help clear some things up for you.
Jim.
ASKER
Jim,
Yes, you are right. The whole issue confuses me. Thanks for the link. I appreciate it.
Yes, you are right. The whole issue confuses me. Thanks for the link. I appreciate it.
Open in new window