Open New Record in Form B with Data from Form A

[Guest]

I have a form A where I choose the associate name and date, and then I feed
that information in a OpenForm command in VB as the where condition to open
the desired record.

I have form B set up to accept a new entry, so if there is a record matching
the criteria, it will display, and if there is no record matching the
criteria, it will display a blank record.

What I'd like to be able to do is if there is no record matching the
criteria, I'd like to move the associate name and date specified on Form A to
the new record, so that I don't have to re-enter it on Form B.

But I don't want to overwrite anything on Form B if it does come up with a
matching record.

Any solutions?

Thank you!

 

[tina]

try adding the following code to FormB's Current event procedure, as

If Me.NewRecord Then
Me!AssociateName = Forms!FormA!AssociateName
Me!DateField = Forms!FormA!DateControl
End If

substitute the correct form, field, and control names, of course.

hth

 

[Guest]

Thank you!

try adding the following code to FormB's Current event procedure, as

If Me.NewRecord Then
Me!AssociateName = Forms!FormA!AssociateName
Me!DateField = Forms!FormA!DateControl
End If

substitute the correct form, field, and control names, of course.

hth

 

[tina]

you're welcome

Thank you!