Requery unbound textbox

[alex]

Requery unbound textbox

Using Access ’03…

I have a form with two subforms.

One of the subforms is set to datasheet view and users can delete
records from this subform (right-click from shortcut menu). My
problem is that when they do, my textbox on the main form will not
requery (it keeps a count of hours).

Strangely, when I modify a record on this datasheet subform (and then
move to another record) my textbox will requery.

My code is in the after_update event of the subform…it’s like the
deletion of a record is not triggering the event.

The code is:
Forms!frmHours!txtHours.Requery

Any thoughts?
alex

 

[alex]

PS:  for deletions put the code in the subforms' AfterDelConfirm event
procedure.

Ken Sheridan
Stafford, England

Worked like a charm Ken.
Thank-you very much!
alex