setting Access critera in VB5

I have a program that writes to 4 different tables, then a query that pulls all the information out. How can I code it so that when a user clicks on a button, it will ask for some information, then put that information into the criteria of the query so I have one listing that comes up, which is then linked to an Access report that will print out?
GatewaytechAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
AndreasSchindlerConnect With a Mentor Commented:
For Example: Your Table is ADDRESS
Name Char(30)
Zip char(7)

Your Query in Access:
Select * from Address where Zip=?

Solution:
make a Table Parameter
ZipPar char(7)

and Change Your Query to:
Select Address.* from Address,Parameter where Zip=ZipPar

By entering Values to the Parameter Table you can choose witch Data the Query will use.

0
 
GatewaytechAuthor Commented:
Wasn't exactly what I was looking for, but it got me to the info that I needed to make it work. You have the points and my thanks. :)
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.