How can I return selected records from the database using a public variable?? Is it possible. I have tried Select * from tblA where tblA.Field Like '"& Public Variable &"'" -- returns an error. Any suggestions??
Thank You in advance
Printable View
How can I return selected records from the database using a public variable?? Is it possible. I have tried Select * from tblA where tblA.Field Like '"& Public Variable &"'" -- returns an error. Any suggestions??
Thank You in advance
Be more specific:
1) What error are you getting.
2) Provide a sample of the code that is causing the error.
Charlie Zimmerman
http://www.freevbcode.com
Thanks for the reply the code was good i had extra quotes in the code it should have been ("SELECT * FROM Pet WHERE Customer_ID = " & Customer_ID).