Poplulate a blank field in a query at runtime (1 Viewer)

[Tiro Cupidus]

I have a union query that selects some fields from an already-existing query. One of the fields I'm selecting has no data stored in the table, so when I run the union, it pops up an input box for me to enter something. I am already creating an input box for the name of the file I'm exporting to (which pops up first), and I want to also use that data to fill in the field. Is there a way to do that and not have the second box pop up?

Sorry if I've been confusing...

Tiro

 

[David R]

Biuild a small unbound form that has the input box for the 'parameter' you want to fill in on both queries. Then on both queries instead of a [Enter value here:] parameter box, substitute Forms!PopupFormName.TextField
Run that small form when you go to start your first query, and run the other queries off of it. As long as that small form is open the queries can pull their information from it and not have to ask you again (think of it as a persistent input box).

 

[David R]

Or try this VBA to pass Parameter values: http://www.access-programmers.co.uk/ubb/Forum7/HTML/003435.html