Unbound Text boxes within a form

[KYLE_DELUCA]

I am trying to set up a small database to track my golf scores. I have a query that determines my average between date ranges and users.

I am trying to set up a form that is full of "Unbound" text boxes, that when a button is pressed it refreshes all the text boxes. I have written the query. It works on its own, but when I try to refresh the Text box it doesn't work. The message I get says "You entered an invalid argument in a domain aggregate function".

I am new to Access and would appreciate any help.

Here is the code I am using when I press my "Refresh" button.

Private Sub REFRESH_Click()
Me.AVG_SCORE = DLookup(AvgOfAVERAGE, AVG_SCORE_ALL_COURSES)
End Sub

Thank you for your assistance

Kyle Deluca

 

[Mile-O]

If you make the ControlSource of the textbox this:

=DLookup("[AvgOfAVERAGE]", "AVG_SCORE_ALL_COURSES")

then, on the click of your command button:

Me.Avg_Score.Requery