Show subform in datasheet view ?

  • Thread starter Thread starter SpookiePower
  • Start date Start date
S

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.
 
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.
 
AstroBoy said:
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.
Click to expand...


Thanks, it works :)
 
Back
Top