Linking forms

  • Thread starter Thread starter iretonshorse
  • Start date Start date
I

iretonshorse

Dim stDocName As String
Dim stLinkCriteria As String


stDocName = "frmLparRL"
stLinkCriteria = "[Nodeid] = [frmLparRL].[Nodeid]"
DoCmd.OpenForm stDocName, , , stLinkCriteria


when I use this piece of code I am hoping that the form will open on
the same record in the next table.
instead of this an alert box comes up Enter Parameter value
FormLparRl.Nodeid

How can I get it to pick up this parameter value automatically?
 
Iretonshorse,

If I understand you correctly, you need this...
DoCmd.OpenForm "frmLparRL",,, "[Nodeid]=" & Me.Nodeid
 
Thanks Steve, that should keep me going for a week!
Iretonshorse,

If I understand you correctly, you need this...
DoCmd.OpenForm "frmLparRL",,, "[Nodeid]=" & Me.Nodeid

--
Steve Schapel, Microsoft Access MVP

Dim stDocName As String
Dim stLinkCriteria As String


stDocName = "frmLparRL"
stLinkCriteria = "[Nodeid] = [frmLparRL].[Nodeid]"
DoCmd.OpenForm stDocName, , , stLinkCriteria


when I use this piece of code I am hoping that the form will open on
the same record in the next table.
instead of this an alert box comes up Enter Parameter value
FormLparRl.Nodeid

How can I get it to pick up this parameter value automatically?
Click to expand...
Click to expand...
 
Back
Top