Selecting a record in subform datasheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeepers321@yahoo.com - 11 Oct 2005 21:34 GMT

I have a form that contains a subform that is set to datasheet view. I
have removed the parent and child links so I could see the entire
table. What I would like to do is that as the user navigates through
the data on the main form I would like the subform to select that same
record. I have tried this multiple ways but if I link the subform to
the main form all I get is that one record and I really would like to
see them all. Any suggestions would be greatly appreciated.

Thanks

Reply to this Message

Allen Browne - 12 Oct 2005 07:20 GMT

What is the purpose of this arrangement?

If the idea is that the user can use the subform to navigate to the desired
record which then loads into the main form for editing, you are using a
subform backwards. A really simple solution is to create an unbound main
form, with a list box for navigation. Then add a subform that is in Form
view (not datasheet) so the user can edit the record.

There is no code to write: just name this list box in the subform's
LinkMasterFields property, and the matching field in the subform in
LinkChildFields.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a form that contains a subform that is set to datasheet view. I
> have removed the parent and child links so I could see the entire
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Jeepers321@yahoo.com - 18 Oct 2005 23:10 GMT

Basically what I am trying to do is to have a Form that allows the user
to edit or add records to the table and on this form have a subform
that shows all the records that are in that table. As the user
navigates through the records in using the main form I need the subform
to highlight the entire row like it would if you were to select that
record in the dataset.

Reply to this Message

Allen Browne - 19 Oct 2005 03:01 GMT

Fair enough. The list box will work well for navigation, as suggested.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Basically what I am trying to do is to have a Form that allows the user
> to edit or add records to the table and on this form have a subform
> that shows all the records that are in that table. As the user
> navigates through the records in using the main form I need the subform
> to highlight the entire row like it would if you were to select that
> record in the dataset.

Reply to this Message