Help--Record Return

[Wilky]

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

[czimmerman]

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).