Change Mainform fields On Click Of Subform row

  • Thread starter Greg Lyon via AccessMonster.com
  • Start date
G

Greg Lyon via AccessMonster.com

I have the following code to populate the subform with records based upon
chosing a company name in a combo box on my main form:

Private Sub Combo170_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Companyid] = " & Str(Nz(Me![Combo170], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Now, that I have a list of records in my subform, I would like to click on
a row in the subform and have the fields change on my mainform that match
the row clicked. The subform is in datasheet view.

Does anyone have code for this??

Thanks,
Greg
 

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