Use data from a query within a form

[acura123]

I am trying to use data derived from a query and add it to my form, however I keep getting a #NAME? error. I am going into field properties and entering the following expression =[Rating Query]!AvgOfRating

What am I doing wrong??

Thanks in advance.

 

[garyd1234]

Set up the text boxes on your form that will hold the data from the query .
On the form properties set the record source to the name of your query and save it.
Now go to each text box on the form and set its control source to the field name (pick from the drop down box) for what you want it to hold from the query.
Now run the form.

 

[acura123]

I did what you said but now I get a blank form.

 

[acura123]

I figured it out thanks!