Finding record on main form

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi all, one final issue and then my project is complete - thanks to everyone
who has offered help and advice of past three weeks.

I'm in a subform, linked to the mainform by a field [RecordId]. By clicking
on a button, I pick up the value of the subform record field [LicenceeId]

I then need to find and display the record in the main form, where
[RecordId] = [Licenceeid]

i have been using the following code:

Lid = [LicenceeId]
MsgBox Lid (to check that I am getting the right value)
Dim rs As Object

Forms!frmOrganisations!CID.SetFocus (this sets focus to the mainform - not
sure if this is necessary?)
Set rs = Me.Recordset.Clone
rs.FindFirst "[RecordId] = " & Lid
Me.Bookmark = rs.Bookmark

Thanks for any help

Alex
 
Alex,
You can do this (if it is an Access Project, this won't
work right):

Dim Lid as Long 'I assume it is a number??? Otherwise
this code won't work

Lid = me.LicenseId 'use the name of the form control

me.Parent.Form.RecordsetClone.FindFirst "[RecordID]=" &
Lid
me.Parent.Form.Bookmark =
me.Parent.Form.RecordsetClone.Bookmark

I hope that helps
 
Back
Top