Hi All,

Thanks again for your help with my previous query.

I've run into another problem. I'm trying to create a query to list a table based on data selected from another table in a list box on a form.

How do i integrate my query with the data in the list box.

eg List box lists table called Environment containing (ID and Environment). Querying CI table containing (ID, EnvironmentID, Name).

Writing the SQL is cake, how i get the data to display is beyond me.

Chris

How do you want to display the data? Do you want it to appear in a report, form or subform?

For a report, for example, base the report on a stored query. Then in the criteria line for EnvironmentID add something like:

[Forms]![frmMyFormName].[cboMyEnvironmentCombo]

You can check that a value has been submitted on the On Click event of the button that launches the report or form, and on a report, you can add a On No Data event, and check for data on the On Load event of the form etc.

At least that is how most top Access developers do it. =
Did that help?


mmcdonal