Where does the data go?

[bubba55]

When you create a query in access, for example



SELECT Customer.LastName, Customer.FirstName, Customer.CellPhone, Customer.Email
FROM Customer
WHERE ((([Customer]![CustomerID])=[Customer]![ID]));

You get a pop up asking for the CustomerID you wish to use. Enter a CustID and the query returns a view with the requested data.

My question is, what happens to the ID that you entered? Is it available for use in other querries?

I want to run a couple of querries where I need CustID as the value passed, but, I only want to have to enter it once. How can I do this?

THANKS!

[June7]

Responses to query parameter prompts are not available for further use. Build a form for users to enter criteria. Queries refer to the form control (text, list, combo box) for the input parameter. Check out tutorials at http://datapigtechnologies.com/AccessMain.htm Go to section Access Forms: Tips - Custom Filter, Search Form