Clear rows on a subform

  • Thread starter Ronald Marchand
  • Start date
R

Ronald Marchand

I have a subform whose selection criteria is controlled by a control on the
main form. Only items that match this are presented for selection in the
subform. This works fine.

The catch ...

If the main form field (ServiceID) is changed, the items on the subform
*MAY* no longer be valid. The key field of the Parent form is EventID and
the subform writes a table with EventID, MemberID as its fields.

The subform is directed to requery after an event update for ServiceID
The main form's table is Events and the subform's table is EventStaff

I have two questions:
1. How would I clear(delete) any subform records for this EventID in the
after update form event?

2. Can I compare the current subform records to the new recordset returned
by the requery and only clear (delete) a record if it doesn't match?

Can anyone guide me on this? or point me to a TA on the subject?

TIA
Ron Marchand
 
Top