Refresh Form

[Guest]

I created a form to log employee payroll hours worked. When you open the form
there is a set of records you can scroll thru using the Navigation Arrows at
the bottom of the form. When the form opens the top row displays their Name -
SS# - etc, and all the lower fields I fill in as required. What I need help
on is when I click on the Navigation Arrows to move to the next record I want
all the fields I filled in to clear when I move to the next record.

Any Ideas ?

 

[tina]

i'm assuming this is a mainform/subform setup, correct? how are the mainform
and subform linked? and how are the underlying tables linked?

hth

 

[Guest]

Tina - Not at all - It's just a simple form not linked to anything - The
headings at the top row of the form come from a query - and when the fields
are filled out I have a record I print out that takes the data right from the
form's fields while its still open.

Thanks - George

 

[tina]

try adding code to the form's Current event to set the unbound controls to
Null, as

Me!ControlName = Null
Me!NextControlName = Null

hth

 

[Guest]

Tina - This works - Thank You ....

try adding code to the form's Current event to set the unbound controls to
Null, as

Me!ControlName = Null
Me!NextControlName = Null

hth

 

[tina]

you're welcome

Tina - This works - Thank You ....