This is pretty much what I need, but the how to clear the query portion wasn't there.
I have a:
Subform (Datasheet): AllAssetsSubform
two text boxes on MainForm:
Upon entering an appropriate username and password into the respective boxes and hitting a Login button, the subform is populated based on those entries.
I'm trying to create what I'm going to call btn_logout.
I'd like this button to not only clear the entries in the two text boxes but also set the subform back to its original state which is void of records.