Requery Parent Form

[Tara]

I have a form (frmCustomer) with a subform (sbfReceipt) linked via
CustomerID. Typically the user chooses a customer from the dropdown and then
adds a receipt for that customer on the subform. At times, there is a need
to void a receipt once it is filled out. There is a Void checkbox (ckVoid)
on the subform for this purpose. When a user chooses to void a receipt, I'd
like for the data in the receipt to be erased and the receipt to be tied to a
generic CustomerID number that was created for all voided receipts. I
thought I might be able to do an After Update event on the void checkbox and
then requery the Parent form, but it's not working. Any ideas on how to
accomplish this?

Thanks!

 

[Klatuu]

I don't think, based on your post, requerying the parent form is necessary.

The approach I would try would be to create an update query that would write
the data in the record you want to delete to the table using the generic
customer ID, delete the record in the subform, then requery the subform.

 

[Tara]

Thanks! It worked perfectly.

I don't think, based on your post, requerying the parent form is necessary.

The approach I would try would be to create an update query that would write
the data in the record you want to delete to the table using the generic
customer ID, delete the record in the subform, then requery the subform.