Sub Form Question

[Giri Palakodeti]

I am opening a form dynamically in VBA code in design view and making changes

DoCmd.OpenForm rs1("Form"), acDesign

But for sub-forms the above statement fails. How can i check if
rs1("Form") is a sub-form and how do I open in design view to make changes
programatically to some of the properties and controls

 

[Damon Heron]

This works for me:

DoCmd.OpenForm "somesubform", acDesign

Damon

 

[Giri Palakodeti]

I am having this error
"This form or report is already being designed as a subform or subreport. To
open this form in Design view, select the subform or subreport and click
Subform in New Window on the View menu."

Anything that I missed??

 

[Damon Heron]

You will get that error if the form on which the subform resides is
currently open in design view. If you want to open the main form in design
view, then use my line, and it will automatically include the subform in
design view.

Damon