Event in main form to erase values in subform

[Benoni2]

I have a form with a subform. I am trying to get a few values in the subform to be cleared when using the after update event on an object in main form. I can't seem to figure out how to access the fields I need to erase in the subform from the object in the main form. Any ideas on how to do this referencing?

 

[GingerR]

Are these BOUND forms (they are based on tables)? What you will be doing is deleting the data from the table that is the recordsource for the subform. Is that what you mean to do?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[TheAceMan1]

How are ya Benoni2 . . . . .

Something like this:

[blue]   Me![purple][b]subFormName[/b][/purple].Form![purple][b]ControlName[/b][/purple] = ""[/blue]

See Ya! . . . . . .

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

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

 

[Benoni2]

Thanks all. this helped much! Yes GingerR, they are bound forms.