Opening subform

K

Kanga

Hi,
I have two forms linked to each other. The parent one is set as singleform
view by default and the child one is set as datasheet view by default.
However when I open the subform from the mainform it comes as singleform
view. Do you know how to have it open as datasheet view?
Thanks a lot
Kanga
 
R

Rick Brandt

Kanga said:
Hi,
I have two forms linked to each other. The parent one is set as
singleform view by default and the child one is set as datasheet view
by default. However when I open the subform from the mainform it
comes as singleform view. Do you know how to have it open as
datasheet view?
Thanks a lot
Kanga
Click to expand...

Even if Datasheet view is set as the default view for a form in design view you
still have to explicitly specify the acFormDS argument to open it in datasheet
view from code or macro.

DoCmd.OpenForm "FormName", acFormDS
 
Top