It's Me.Requery not Me.Query.
And it can go in any event, like the click event of a button. If the requery
clears out the input field, then just declare a variable, set the variable to
that value, requery, then put the variable value back in your field.
=====================
'put this in your event
Dim strInputValue as String
strInputValue = Me.MyInputField
Me.Requery
Me.MyInputField = strInputValue
Thanks for responding tkelley. I want to refresh data in two fields on my
form and keep the data in the input field that's entered once each morning.
Not sure of where to put the me.query. Tried that once and got an error
message. Does me.query have to be setup as a macro first?
I'm not quite sure what you want to do.
[quoted text clipped - 12 lines]