Emma has attended:
Access Introduction course
Query Fields and criteria from combo box on form
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!
RE: Query Fields and criteria from combo box on form
Hello Emma
Thank you for your question.
As we have been experiencing a high volume of posts in the forum, it has become necessary for us to introduce a fair usage policy to ensure we are able to respond to delegate questions as quickly as possible.
The policy is visible when you log into your delegate account, on the Support Forum tab.
In accordance with the policy, we are able to respond to posts that are directly related to what is covered on the courses you have attended with us. Therefore we are able to assist you with queries relating to the content of the Access Introduction course, but not queries relating to VBA or other applications.
Kind regards
Amanda
