Filtering an Access Query from VB

I want to open an access db using vb code, and change the dbgrid Recordset source depending on sql code.  Is this possible?

Lets assume that I have an access query that has 20 names, I want to write code that depending on what name is in a textbox in VB, it will pull only those records in vb.  

If that is not possible, then I would choose to write code to change the sql in the actual access database (from within vb)  to fit what is in the text box in VB form.  Is this possible?

Thanks for your help!
thienAsked:
Who is Participating?
 
stevesmConnect With a Mentor Commented:
Either way is possible if your willing to write the SQL for the dbgrid based on your text box. Although its easier to use the data form wizard to do what your looking to do and modify the code.
Let me know if this is what your looking for if not reject my answer and comment back

Regards Stevesm
0
 
thienAuthor Commented:
Edited text of question
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.