Hey... I'm in the middle of making a form.
This form contains a sub form which is a query. This query has a variable, and that is the criteria. I would like this variable to be equal to a text box in the main form.
ie.
in the main form you maybe able to cycle through a list of colours.
then in the subform, it may query for all the people who have "x" colour eyes.
so lets say you are cycling through the list in the main form and you get to "brown", I would now want "x" in the sub form to equal "brown"
This form contains a sub form which is a query. This query has a variable, and that is the criteria. I would like this variable to be equal to a text box in the main form.
ie.
in the main form you maybe able to cycle through a list of colours.
then in the subform, it may query for all the people who have "x" colour eyes.
so lets say you are cycling through the list in the main form and you get to "brown", I would now want "x" in the sub form to equal "brown"
Facebook
Twitter