Inserting data in forms

[Dudley]

I am trying to create a command button in a form which inserts standard data
in other forms. I can open another form with:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "DirectorSubForm"

stLinkCriteria = "[EnvelopeNumber]=" & Me![EnvelopeNumber]
DoCmd.OpenForm stDocName, , , stLinkCriteria

But if I then try to insert data with Me.Forename= "DUDLEY", Access does not
find Forename, only controls in the original form.

Thanks for any help.
Dudley

 

[Dudley]

Thanks for your help.
Dudley

Use:

forms!formname.forename instead of me.forename

(replace with your formname of course)

Bonnie
http://www.dataplus-svc.com

I am trying to create a command button in a form which inserts standard data
in other forms. I can open another form with:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "DirectorSubForm"

stLinkCriteria = "[EnvelopeNumber]=" & Me![EnvelopeNumber]
DoCmd.OpenForm stDocName, , , stLinkCriteria

But if I then try to insert data with Me.Forename= "DUDLEY", Access does not
find Forename, only controls in the original form.

Thanks for any help.
Dudley