How to empty all the textfield in subform when form load?

pin

New member
Local time
Today, 21:56
Joined
Aug 16, 2000
Messages
5
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.
 
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
 

Users who are viewing this thread

Back
Top Bottom