Subform not displaying records in list format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Try Hard - 15 Apr 2008 09:23 GMT

Hi everyone. I have a problem that I've been struggling on for a while and
quiet frankly need help!

Ive have a main form based on a query and a subform based on an existing
table. all the information required is their at it all works even when I
enter data into subform (which is somewhat amazing for me). Is it possible
to show all records (one under the other) for the selected choice (ie. from
main form) in the subform rather than having to use the navigation bars to go
to the next record, I only want to use the navigation bars to go to the next
NEW record I want to update with data.

Thanks Anyone

Reply to this Message

Jeanette Cunningham - 15 Apr 2008 09:31 GMT

Hi,
if you put the subform in either datasheet view or continuous view, you will
see all the matching child records for the current main form's KeyID.

Jeanette Cunningham

> Hi everyone. I have a problem that I've been struggling on for a while and
> quiet frankly need help!
[quoted text clipped - 12 lines]
>
> Thanks Anyone

Reply to this Message

Try Hard - 15 Apr 2008 09:47 GMT

Thanks Jeanette, I already have the subform in datasheet view and have tried
your other suggestion of continuous view, it does not work (for me anyway).
The records which I want to group are those in the subform when they related
to the KeyID in the mainform, the mainform is based on a query any I am
having to navigate through each record.
Thanks

> Hi,
> if you put the subform in either datasheet view or continuous view, you will
[quoted text clipped - 18 lines]
> >
> > Thanks Anyone

Reply to this Message

Jeanette Cunningham - 15 Apr 2008 12:15 GMT

Are you asking to show all the records for the main form without having to
use the navigation buttons?
If you put the main form in datasheet view or continuous view, you won't be
able to put a subform on it.
If you made the main form datasheet or continuous, you could try it with the
subform on the footer of the main form.
I haven't used this myself, but have seen it suggested in the discussion
group.

Jeanette Cunningham

> Thanks Jeanette, I already have the subform in datasheet view and have
> tried
[quoted text clipped - 33 lines]
>> >
>> > Thanks Anyone

Reply to this Message

Linq Adams - 15 Apr 2008 13:06 GMT

I could be wrong, but it sounds to me as if you haven't created the
Child/Master links joining the main form and subform. If this is the case,
from the subform's Property Sheet goto the Data tab and set these properties.
Then when you move to a record on the main form, the subform will display
only related records.

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message

Fav - 15 Apr 2008 16:59 GMT

Hi
Can anybody help me. I am not good in Access.
I'm trying to add value in record 1 and value in record 2 and put it in the
main form. For example
TotalSales = Salesitem of record 1 + Salesitem of record 2
Salesitem is a field in Subform while TotalSales is a field in Main form

Signature

itswell

Reply to this Message