Navigate from a record in 1 form to SAME record in another form 1

[Ogart]

Situation:
->Query 1: Asks for user, which drives Form 1.
->Form 1: The records that USER "owns". It could be many. Form 1 is basically there to give a list of the records that they are working on. Sort of an open items list.
->Form 2: The main data entry form for the rest of the work.
ID: That's the field that I'm keying off of.

What I want to do is click on a record in Form 1, which then opens form 2 at the same record. Form 1 has a button by each record that will pick up the correct "ID". The code looks like this:
Dim IDNum As Integer
IDNum = Me.ID
MsgBox "You just selected number" & IDNum
DoCmd.OpenForm "fMain"

I need to have some flavor of DoCmd.FindRecord that gets to the record that has the same ID.

I'm not seeing it, though no doubt a real programmer will remember fondly a homework assignment as a Freshman CS student that is related.

Thanks in advance for the help.

Chris

 

[TheAceMan1]

How are ya Ogart . . . . .

Add the following code to the [blue]On Load Event[/blue] of Form2:

[blue]   Dim db As dao.Database, rst As dao.Recordset, frm As Form
   
   Set frm = Forms![purple][b]Form1Name[/b][/purple]
   Set db = CurrentDb()
   Set rst = Me.RecordsetClone
   
   rst.FindFirst "[purple][b]ID[/b][/purple] = " & frm!ID
   Me.Bookmark = rst.Bookmark

   Set frm = Nothing
   Set db = Nothing
   Set frm = Nothing[/blue]

See Ya! . . . . . .

 

[Ogart]

Works like a charm. Thanks Ace!