From form to form

[jtundra05]

I have a "Problem Report" form with an ID#. On this form I have a control button that opens a "Field Problem Report" form.
How do I make the "Field Problem Report" form open and autofill the "Problem Report ID#" field with the Problem Report's ID# so I dont have to enter it manually?

 

[John Big Booty]

You could use the OpenArgs portion of the DoCmd.OpenForm statement to pass the ID# to your new form.

 

[missinglinq]

To expand on the advice from the 10th planet, something like this, substituting your own exact names.

In your calling form:

Private Sub YourButtonName_Click()
  DoCmd.OpenForm "FieldProblemReport", , , , , , Me.ID	
End Sub

Then, in the FieldProblemReport form:

Private Sub Form_Load()
  If Len(Nz(Me.OpenArgs, "")) > 0 Then
    DoCmd.GoToRecord , , acNewRec
    Me.ProblemReportID = Me.OpenArgs
  Else
    DoCmd.GoToRecord , , acNewRec
  End If
End Sub

 

[John Big Booty]

Thanks missinglinq

Dim Count As Integer
Count = 1

Do Until Count = 100
     Write by Hand "I must be more expansive in my answers"
     Count = Count + 1
Loop