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?

[Webinar] Streamline your web hosting managementRegister Today

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
All Courses

From novice to tech pro — start learning today.