Query Fields and criteria from combo box on form | Access forum

Hi there,

I have set up a form which has 2 combo boxes on, the second of which is visible depending on the selection from the first combo box. For each of the selections I have a text box that displays what has been selected. I have read elsewhere this can be useful when putting answers into queries. This is working fine.

I now need to take the answers from each of the text boxes and use them in a query. The combo box 1 answer is the field(which is in a table that is joined to the main table for the query). I currently have the following typed in the field of the query:

Expr1: [Forms]![Form1]![LevelSelectionText]

Then in the criteria, I have the following;

[Forms]![Form1]![LevelSelectionNameText]

This doesn't return any data, but I know that the setup of the query itself will work as have tested with fixed fields and criteria.

It also doesn't like me pre-selecting the table to take the field from and I'm not sure why. It will always be the same table.

I hope that makes sense. Hopefully you can help as I have tried everything I can think of.

Thanks!