Selecting a record in subform datasheet

  • Thread starter Thread starter Jeepers321
  • Start date Start date
J

Jeepers321

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
 
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.
 
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.
 
Back
Top