How to import a field value from another form?

[PoorCadaver]

I have a form (Form1) that shows a post in a table (Tbl1). There is a button that opens another form (Form2) for adding information to another table (Tbl2).



In Form2 I want to import a field value from Form1, i.e. the ID number of the post.

I can't find a way of doing this but I don't think this is impossible to do...

Anyone here who knows how to do?

[rzw0wr]

I have never done this myself. I just recently been told of this.
try the docmd.openform using the openargs.
Docmd.Openform "yourForm", ,,,acWindowNormal,The ID of the Post

Dale

[Missinglinq]

Here's a step-by-step for the method rzw0wr suggested:

In the Primary Form:

Private Sub Go2SecondaryForm_Click()

 If Nz(Me.RecordID,"") <> "" Then
  DoCmd.OpenForm "SecondaryFormName", , , , , , Me.RecordID
 Else
  MsgBox "A RecordID Must Be Entered First!"
 End If

End Sub

In the Secondary Form:

Private Sub Form_Load()

    DoCmd.GoToRecord , , acNewRec
    
    If Nz(Me.OpenArgs,"") <> "" Then
      Me.RecordID = Me.OpenArgs
    End If

End Sub

You'll need to replace Go2SecondaryForm with the actual name of your Command Button and SecondaryFormName with the actual name of your second Form and RecordID with the actual name of your Control.

Linq ;0)>