Same input for multiple user input boxes

[john3j]

Hey guys,

I have created multiple queries that a user is supposed to specify the "Division" that they are running a report for. The problem is, they are prompted sometime 6 times to enter the same information. Is there a way to tie inputs together so that the user only has to input the information once? The "Division" field is not in the same order on all of the queries being ran. Thanks!

[OBP]

The input should only be made once on a form (see the response to your previous Thread), leave the form open with the selection made and it is available to all of the queries.

[CreganTur]

Create a custom form where they can provide all the details up front and then feed the info to the queries. See this thread (http://www.vbaexpress.com/forum/showthread.php?t=28665), specifically OBP's post about linking the object values of a form into query criteria.

HTH:thumb