Clicking on a form record to open another query

[scottyjohn]

Hi all,
I have QueryA which returns three fields in a List box on a report. I have added the behaviour to open a new query QueryB which runs using a value from column 1 in QueryA, but I cant get this run correctly. How do you tell the new query QueryB to get its criteria for the query from the column 1 in QueryA? I cant seem to get it to pass the data to the next query.

John

 

[dhookom]

The value should be available from the List Box. Typically the list box would be bound to column 1. Then try something like the following expression in the criteria of the query:

   Forms!frmYourForm!lboYourListBox

Duane
Hook'D on Access
MS Access MVP