View Full Version : Sub Forms


Dave Hair
08-07-2000, 06:40 AM
VBA does not see my subforms. It does see my forms. Any clues??

Robert Dunstan
08-07-2000, 07:48 AM
Dave your post is a little vague so I'll give you a general answer

If you try to reference subforms form your main form in VBA the use the syntax -

[Forms]![your main form name]![you subform name].Form

or

Me![your subforms name].Form

This will allow you to make changes to subform properties i.e AllowEdits, Enabled etc

e.g Me![you subform name].Form.Visible = True

Are you getting any VBA error messages?

Dave Hair
08-07-2000, 08:54 AM
Thanks. I'll try some of the syntx you provided. I get those weird message like it just doesn't know the subform exists.