Ok.
I am having a bad mental day (sinus headache).
I have a form with 2 combo boxes, 1 Text Box, and one button.
Combo Box #1 is the location.
Combo Box #2 is the Month and Year.
The button runs the query.
The text box is where I want the result of the query to go.
The query runs great. It gets the data from the 2 Combo Boxes and passes it to the query and I get one result. Perfect.
Now how do I get that one result to populate on the form in the Text box?
The form is not set in stone, so other easier/more straight forward ways are readily acceptable. Thanks!!!
I am having a bad mental day (sinus headache).
I have a form with 2 combo boxes, 1 Text Box, and one button.
Combo Box #1 is the location.
Combo Box #2 is the Month and Year.
The button runs the query.
The text box is where I want the result of the query to go.
The query runs great. It gets the data from the 2 Combo Boxes and passes it to the query and I get one result. Perfect.
Now how do I get that one result to populate on the form in the Text box?
The form is not set in stone, so other easier/more straight forward ways are readily acceptable. Thanks!!!
