Form field references query

[jamphan]

How can I get my form filed to return the results of a query that I have? For example I have my query set to use the month and year that are in my form in a cbo to get the desired results for Balance Growth. I want this Balance Growth result to show in my form field after the year is updated in my cbo. Right now in my Balance growth field on my form I have it linked to the query but it has the #Name? in it. Thanks for any help.

 

[FoFa]

I think once you select your year, you will also have requery your form/control.

 

[jamphan]

Not sure what you mean. I am having trouble linking the form field to the query.