Clear Fields

[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

 

[Allen Browne]

Use the Current event of the form to assign Null to the unbound controls.

 

[Guest]

Can you elaborate how to do that.

Thanks

Use the Current event of the form to assign Null to the unbound controls.

 

[Allen Browne]

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