Using sql statements to access a DB

[oneillc9]

How would I use an SQL statement in the vb code to select a field using a string variable entered by the user?

for example:

......"Select * from MemDetails where MemberLName = gstrSearch"

I dont know the code to put before it either.

Need an answer fast!!!

Cheers

 

[TPM]

"Select * from MemDetails where MemberLName = '" & textbox.text & "'"

TPM