Passing unbound field data from Form to Continous Form, how do you

[claytonjgordon]

I checked the FAQ and ran a few searches and couldn't find anything matching my issue.

I have a simple form that has the user enter an account number and date into unbound fields and then push a button. I need assistance taking the values of these two fields and passing the data into two serperate and bound (to the main table) fields as a new record of a continous form on the button click.

I have been playing with the OpenArgs property of the openforms command but that doesn't seem to be working even when I try to pass just one of the fields.

Any ideas.

For information on why I'm trying to populate the form this way, please see thread702-1280282 for reference.


Dominus Nihil
(Master of Nothing)

 

[claytonjgordon]

Got it with this:

Private Sub Form_Load()

Dim NewAcct As String
Dim NewFLD As Date

NewAcct = Forms![New Request Form].LoanNumber
NewFLD = Forms![New Request Form].CurrentFLD

If Me.Acct_ = "" Then
    Me.Acct_ = NewAcct
        ElseIf IsNull(Me.Acct_) Then
            Me.Acct_ = NewAcct
End If

If Me.FLDD = "" Then
    Me.FLDD = NewFLD
        ElseIf IsNull(Me.FLDD) Then
            Me.FLDD = NewFLD
End If

Dominus Nihil
(Master of Nothing)