Auto Fill

[Derrick T. Davidson]

Hi I am unsure if this is possible but if you don't ask .................



I have a form [transactions] which is completed with basic details.

When I complete it I have 6 or 7 other pop up forms [CatBreakTrips], [CatBreakHotels], etc. these break down the basic information into information relevant to the category so whatever the category is I open the relevant breakdown pop up.

Here is the question when I open the pop up[s] is it possible to auto a fill/copy a [transactionId] in the pop up form, from the [transactionID] (which is the Auto Number Primary key of the transaction record) in the open transaction record?

[Missinglinq]

In the Primary Form:

Private Sub Go2SecondaryForm_Click()

 If Nz(Me.transactionId,"") <> "" Then
  DoCmd.OpenForm "Secondary Form", , , , , , Me.transactionId
 Else
  MsgBox "A transactionId 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.transactionId = Me.OpenArgs
    End If

End Sub

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

Linq ;0)>

[Derrick T. Davidson]

Wow this is "NEARLY" what I wanted, when I put in the code it opens the new record and puts a new number in the [secondaryformID] (primary key).

However on the [secondaryform] I have a [secondaryformID] (primary key) plus another entry [transactionID] (primary key of [transactionform]) which is where I wanted the ID number to show up.

Is this possible??

[Derrick T. Davidson]

Works great thank you

[Missinglinq]

Glad we could help!

Linq ;0)>