Inserting data in forms

  • Thread starter Thread starter Dudley
  • Start date Start date
D

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
 
Thanks for your help.
Dudley

bhicks11 via AccessMonster.com said:
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
Click to expand...
Click to expand...
 
Back
Top