Clear Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that just the top row of fields are bound to a query. The
remaining fields I fill in the data and I print a report while the form is
open. Next I use the Navigation button to scroll to the next record. The
problem I have is the data I typed in the unbound fields do not clear when I
scroll to the next record. Is there some code I can add to each of the fields
I want to clear when I scroll to the next record ?

Thanks
 
1. Open the form in design view.

2. Open the Properties box.

3. Looking at the properties of the form (not of a text box), choose On
Current on the Event tab.

4. Set the property to:
[Event Procedure]

5. Click the Build button (...) beside this.
Access opens the code window.

6. Between the "Private Sub Form_Current()" and "End Sub" lines, enter your
code, such as:
Me.[Text0] = Null
Me.[Text99] = Null
 
Back
Top