linking Main form in single form view to subform in datasheet view

  • Thread starter Danielle Haile via AccessMonster.com
  • Start date
D

Danielle Haile via AccessMonster.com

I'm trying to create a main form in (single form) to highlight fields
clicked on the subform in (datasheet format). All the information is in
one table, but the table has too many columns. To create a better view I
want to be able to on the datasheet row of the subform, and have the main
form display additional fields to keep from scrolling to the right because
there are so many columns.

I like and chose the datasheet format to list all of the data (701 records)
so that I can click on the column and sort if I want to.

Does anyone have a solution??
Thanks!
 
R

Rob Oldfield

Something like this in the current event of your subform....

Private Sub Form_Current()
Dim rs As Object
Set rs = Parent.Recordset.Clone
rs.FindFirst "PKName = " & str(Me.PKControlName)
Parent.Bookmark = rs.Bookmark
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top