subform in table view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jlwood44@hotmail.com - 28 Oct 2005 21:17 GMT

I have seen this done, but I don't know how to do. I have a form with a
subform. The form is fine as it is, but I want the subform to look like a
table.
This way I can see 'all' the entries of test scores for the individual that
is shown on the form.
The other major issue if I was in 'table' and I had a first score, then the
first score would show and the second would also show, and be looking for my
entry. At this point I only get to see one record at a time, and the fields
are separate.

Reply to this Message

Van T. Dinh - 28 Oct 2005 23:32 GMT

Open the Form being used as the Subform in DesignView and change the
Property "Default View" to Datasheet rather than Normal View.

I got no ideas of your description of "first score" and "second score".

Signature

HTH
Van T. Dinh
MVP (Access)

>I have seen this done, but I don't know how to do. I have a form with a
> subform. The form is fine as it is, but I want the subform to look like a
[quoted text clipped - 9 lines]
> fields
> are separate.

Reply to this Message

jlwood44@hotmail.com - 30 Oct 2005 23:27 GMT

I understand that you were not aware whether I was talking about fields or
records when I said "first score" and "second score". They were referring to
different records.

I did not originally see the "Default View" from the top corner of the
subform, but by looking at "View" at the top toolbar I was able to get
datasheet view, so it is working fine. Thank you.

> Open the Form being used as the Subform in DesignView and change the
> Property "Default View" to Datasheet rather than Normal View.
[quoted text clipped - 14 lines]
> > fields
> > are separate.

Reply to this Message