Clear values on query based form

[JackieEVSC]

I have a form (frm_Inventory) that is based on a query that requires the end user to enter (or scan) an asset barcode number. The information associated with that tag number is displayed. If that's the correct information, the user can then click a button which creates a repair ticket for that device (which writes the info to the database, assigns an auto-numbered repair ticket) and opens a second form (frm_RepairInfo) where they user can enter the damage/problem with the unit and print a repair ticket. This part works perfectly.

The problem comes when the user needs to create another ticket. I have a button on this form (frm_RepairInfo) which opens up frm_Inventory. When you click this button, it's not running the query again or prompting the user to enter an asset tag, which means the information from the previous query is still populated on the form.



I know the answer is glaringly obvious to someone who knows vba well, but I'm stymied! How do I clear the values so that it runs the query every time frm_Inventory is opened?

[JackieEVSC]

Nevermind ... I have the form name misspelled. (duh!)