View Full Version : How to empty all the textfield in subform when form load?


pin
08-25-2000, 08:48 PM
I have do the form that consist of subformwhich is presented incontinuous view. I would like to know how can i empty all the textfield inn the subform when the form load.
I use this command line:
me!textfield = ""
in when form load event.
to empty my main form textfield. So how can i do for my subform as well?

Thanks.

accesswatch
08-27-2000, 04:13 PM
The following is an extract from the helpfile showing how to reference a subform control. Note the .FORM after the subform name (ctlSubForm) it is the .FORM that takes you to the Sub Form.

example showing how to refer to a control named NewData on a subform called ctlSubForm contained in the form called OrderForm:

Forms!OrderForm.ctlSubForm.Form!Controls.NewData

Hope this helps
Trevor from www.accesswatch.co.uk (http://www.accesswatch.co.uk)