Subform view as form not datasheet

[Caroline]

Hello,
I have a form with a subform in it and I would like that subform to only
show as a form, not as a datasheet. How can I do that?
Thanks,
Caroline

 

[Tom Wickerath]

Hi Caroline,

Open your subform in design view. Display the properties (F4) for the
subform. You should see the word "Form" in the blue title bar of the
properties dialog. On the Format tab, change Default View from Datasheet to
Single Form.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[John Spencer MVP]

I'm not sure this will work if the form is being used as a subform, but there
is a form property that can be set to allow or forbid datasheet view.

YOu might try setting the Form's Allow Datasheet view property (on the format
tab) to No and see if that works for you.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County