Refresh subform 1

[melaniecarr23]

I have a form with a subform on it. When the doctor approves the items on the subform and moves to another record (on the subform) I would like the subform to refresh itself or reload (not sure what to call it).

I know I have to use the after update event, but don't know how to make it refresh itself so the records that no longer apply disappear.

Any help would be great!

Thanks,
Melanie

 

[Mike555]

You could try this as your AfterUpdate event...

[Forms]![MainForm]![SubForm].[Requery]

Thanks.

 

[melaniecarr23]

Thanks so much Mike! It worked! That just makes my form so much better.