Show subform in datasheet view ?

[SpookiePower]

If I put a subform on my mainform all the data from the table
connected to that subform is displayed one record at a time
in textboxes. How can I get the subform to be displayed as a
datasheet view insted, so that I can see more than just one record
at a time ?

I found out that if I put a query in the source object property
of the subform, then it will be displayed in datasheet view, but
is it the right thing to do ?

I have been told many time that it is the name of the subform
that should be in the Record Source property.

 

[AstroBoy]

The easiest and best way to do this is to go into design mode with the main
form. RIGHT click on the subform and select properties.
In the Format tab of the properties window is a property called Default View.
From the dropdown list to the right of that select datasheet.

that should do it.

 

[SpookiePower]

The easiest and best way to do this is to go into design mode with the main
form. RIGHT click on the subform and select properties.
In the Format tab of the properties window is a property called Default View.
From the dropdown list to the right of that select datasheet.

that should do it.

Thanks, it works