Thank you. I got it to search and open form ny employeeID. How would I get it to search from LastName,FirstName? When I try to type in VBA with "LastName=" &LastName it pops up an error...
Reply from Richard Rost:
Remember that STRING values have to be enclosed in QUOTES:
"SELECT * FROM CustomerT WHERE LastName=""" & LastName & """"
Access translates "" inside a string to an actual double-quote, so you get:
SELECT * FROM CustomerT WHERE LastName="Smith"
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 302.
