Show all records on form

[Brightspark98]

How do I add a table to my form to show all entries in the table.

I have a table tblDetails that stores



DetailsID---UserID---ActivityID---WeekNo

When I try to put this table on the form I only get 1 record displayed.

How to I show the full table content?

Many Thanks

[JoeM]

Open up your Form in Design View and view Properties.
On the Format tab, change the Default View from "Single" to "Continuous".

[Brightspark98]

It is a datasheet form or table with full content I wanted to add to the original form.
Is this possible?

[JoeM]

If you change it to Continuous View like I described, and arrange the fields so that they are aligned next to each going across (instead of down), and resize the Detail section to not have extra space, it should give you the look you desire.

[Brightspark98]

Hi,

I've got the continuous form set up & it works great on its own.

When I add it as a subform it does not show any records. Just the current record from the main form

Does anyone have any ideas?

>>>I deleteted & replaced the subform with and all works well.

Thanks