Subform views

[Guest]

When setting up a subform in design view, I keep setting my subform to Form
View. However, when I view the main form in Form view, my subform always
changes into Datasheet view. Why is this?

 

[Guest]

Hi.

Why is this?

Either the subform's Default View is Datasheet, or the Default View of
Single Form is correct, but Form View isn't allowed. These settings can be
set in the form's Properties dialog window or via a VBA procedure that
executes when the form opens. Most likely it's the Properties dialog window
setting.

Close the main form and open the subform in Design View. Open the
Properties dialog window and select the Format tab. Ensure that the Default
View Property is Single Form and ensure that the Allow Form View Property is
set to Yes. Save the subform and close it. Open the main form, and you
should see the subform in Form View, not Datasheet View.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

['69 Camaro]

Hi.

However, when I view the main form in Form view, my subform always
changes into Datasheet view. Why is this?

Either the subform's Default View is Datasheet, or the Default View of
Single Form is correct, but Form View isn't allowed. These settings can be
set in the form's Properties dialog window or via a VBA procedure that
executes when the form opens. Most likely it's the Properties dialog window
setting.

Close the main form and open the subform in Design View. Open the
Properties dialog window and select the Format tab. Ensure that the Default
View Property is Single Form and ensure that the Allow Form View Property is
set to Yes. Save the subform and close it. Open the main form, and you
should see the subform in Form View, not Datasheet View.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.