Clear Sub Form

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

Guest

On my form the top row of fields are bound to a query. All the remaining
fields are unbound and I would like for them to clear as I navigate thru the
records. I haven't been able to figure that out so I created a sub form for
all the unbound fields and though I could get them to clear when I scroll
thru the records but thats not working either - how can I get the sub form to
clear each time the main form advances to each new record ?

Thanks
 
George said:
On my form the top row of fields are bound to a query. All the remaining
fields are unbound and I would like for them to clear as I navigate thru the
records. I haven't been able to figure that out so I created a sub form for
all the unbound fields and though I could get them to clear when I scroll
thru the records but thats not working either - how can I get the sub form to
clear each time the main form advances to each new record ?
Click to expand...


Forget the subform. Just use the form's Current event to
set each of the unbound controls to Null.

Or do you mean sonething els be "clear".

And what good are a bunch of unbound controls that are
frequently erased?
 
George, is this your payroll entry form?
Couple of questions.
1. The way you are trying to do this, it looks like you want to replace
whatever hours are in the last payroll with the current payroll hours. You
want the form to automatically erase the last payroll when you display the
employee's record on the form.
Is this correct?

2. Let's assume the table you are updating is called tblHours. You keep only
the current payroll in your tblHours table. Is that correct?

3. Are we dealing with more than one table in your query? Like an Employee
table as well as tblHours table? Yes/No?

4. Do you have it working now if you just type over the old fields? Yes/No?

5. If you scroll thru the employee records, does the form update each
employee with the same hours that don't erase from the form? Yes/No?

6. Or does it do nothing? Yes/No?

7. Any additional information that might help? Like what is the reason that
your data entry controls are unbound?

Answering these question will give us an idea of what you want, and what
currently is wrong and needs fixed.
UpRider
 
Back
Top