Copy filed value to use a query criteria

  • Thread starter Thread starter Evan
  • Start date Start date
E

Evan

I have 2 "criteria" queries (not sure on the lingo, but a query that prompts
for user input for the critera) that I use very often. Query1 has a filed
called Trans, which stores the number for a related transaction which I then
modify in Query2. I commonly enter data in Query1, copy (control-c) the
value from the Trans field, launch Query2, paste (control-v) the value from
Query1 Trans field into the pop-up, hit enter.

I would like to automate the copy, close, double-click to launch Query2,
paste, enter part.

Anyone care to get me started????

Thanks
 
I have 2 "criteria" queries (not sure on the lingo, but a query that prompts
for user input for the critera)
Click to expand...

"Parameter" query, usually.
that I use very often. Query1 has a filed
called Trans, which stores the number for a related transaction which I then
modify in Query2. I commonly enter data in Query1, copy (control-c) the
value from the Trans field, launch Query2, paste (control-v) the value from
Query1 Trans field into the pop-up, hit enter.

I would like to automate the copy, close, double-click to launch Query2,
paste, enter part.
Click to expand...

Ummmm... how about using Access relationally, and skipping the entire
copy, close, doubleclick etc. stuff!?

Join Query2 to Query1 and pick up the field directly.

If you'ld please open the two queries in SQL view and post the SQL
text here, someone should be able to suggest a modification to Query2
to make this exercise much simpler.
 
Back
Top