Control used to run new query in a FORM

[Guest]

I have a form that displays unit information for a piece of equipment. Upon
opening, the user is prompted to enter a UNIT #, this query brings up the
data on that unit, as well as some saftey test fields for the user to fill in.

The form obviously only displays 1 units information at a time... What I
would like to try and accomplish is to have a control button that would
re-run that opening query and display a new Units set of information and test
result fields.

I Currently have a control button that simply closes the form and returns
the user to the switchboard menue where he / she simply selects the form
again and re-opens it... but this seems like too much work for a simple
procedure....

I am guessing that there is likley a way to accomplish the same effect with
far less steps.

ie.
(Save the current data, refresh the form and run the query which would
prompt the user for a new unit #)

Any advice, pointers, comments would be appreciated.

Thanks in advance...

 

[Guest]

In the simplest terms:

Save the existing updates. Reset your Unit# field to "", and requery your
subform. Then use Unit#.SetFocus.

This should reset the form.

Or, as ugly as it is, close the form and reopen it. Definitely not elegant,
but it works.

Sharkbyte