Issuin Quieres Based On A Given "cell" Value

I'm developing a complex form that will pull records/fields from a number of tables. The form is designed in a tabular form - with a form showing a number of "logical" records - each of the records consisting of fields from a number of tables.

The first column of the records is genetated using a query that results in a unique set of values. When originally displayed the second (and the other columns) will have null values. What I want to happen is that when the user goes to the relevant second columm in a row he is displayed with a drop down list of possible values depending on the value in the first column/row. The possible values being determined by the a query on another table given the first column/row.

as a concrete example a form will display the following 3 rows, each with 3 fields. The first field having a country displayed:

row_1 <USA> <null> <null>
row_2 <UK> <null> <null>
row_3 <CAN> <null> <null>

When the user selects row_1 in the second column then a combo/list box should display the hotels appropriate to the USA - and the hotels being found by a query on another table based on the "USA" value in the first field in the row. Likewise if the user selects row_2 and the second field the hotels in the UK will be listed in a drop down box.


I've tried parameter driven queries and that does not seem to allow specific column/row values to be fed into thea query - neither does event notifications seem to be able to have a function parameter of the colum/row value so a VBA query could be issed

Any on have ideas how I can do this?

John