I have a form (Form1) that gets a calculated value from a query. Form1 is not based on the this query though (based on another query), so I am currently opening another form (Form2)to store the value of the query temporarily and then use the value of the field in Form2 as the control source for the field in Form1. This works, but I am sure it is not the best way to do it.
I could not get it to work by opening the query and then making the control source for the field in Form1 be the value of the field in the query. All I got back was ?Name.
Got to be a better way. Any suggestions are appreciated.
I could not get it to work by opening the query and then making the control source for the field in Form1 be the value of the field in the query. All I got back was ?Name.
Got to be a better way. Any suggestions are appreciated.