OnClick from form make that record current in another form

[zozew]

Hi,

I tried this and it almost works....I have a mainForm with a recordset of profiles. In another form (CommonForm)on the MainForm I have a datasheet displaying profiles that have common data. What im trying to do is when i click on the records in the CommonForm i would like the currentRecord in the mainForm to jump to the record i clicked on.

Problem:
I have made it so that every profile has a unique keyID the ProfileID and when i click on the record i tried to use GotoRecord, the MainForm jumps to a record but sadly it jumps to the row number of ProfileID and not the value of ProfileID.
I suspect that is so because i have sorted the MainForm and the records are not sorted in KeyID (ProfileID)...

How do i get the row number to use in GotoRecord for a specific KeyID

THX

Zozew

 

[zozew]

Hi all ive sorted it with this:

With Forms!InmatesProfile.RecordsetClone
  .FindFirst "InmateID = " & Me!InmateID
  If Not .NoMatch Then Forms!InmatesProfile.Bookmark = .Bookmark
End With