Update subform after entry

[katiekat]

Hi All, quick question!

I've got a form with 2 subforms: one data entry(A), one displaying records(B) that may or may not have just been added using the data entry subform.

How can I make the records show up in B as they are entered in A? Something in the afterupdate event telling B to requery?

I tried me!B.requery in the afterupdate event of A, but that doesn't really make sense, and anyway, it didn't work. I also tried using that command to requery the table the subform is based on. No dice. I think I have the right idea, I just don't know how to pull it off.

Thanks for the help!
Kate

Holy tek-tips batman!:-0

 

[PHV]

Something like this ?
Forms![mainform name]![subform B controlname].Form.Requery

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[katiekat]

All the action is happening in the subforms though.

Would this work in the afterupdate of [A]?

forms![A)!.form.requery

Holy tek-tips batman!:-0