open a form to child record using bound text box "on click"

  • Thread starter Thread starter lenox.noah
  • Start date Start date
L

lenox.noah

Here the problem~
I have a field "JobName" in a continous view, sub-form "sfrm_Jobs".
The sub-form is in "frm_Customers". I want to use the"JobName" field's
"on click" event to open "frm_Specs" and have it filter out everything
but the records relating to the "JobName" field. "JobID" is the
primary key. The wizard will set it up to open the form but I get an
error when I try to modify or create new records. The error message
says "Jet cannot find a record in the table 'tbl_Jobs' with key
matching field(s) 'JobID' "

Thanks in advance
 
Here's the problem~
I have a field "JobName" in a continous view, sub-form "sfrm_Jobs". The sub-form is in "frm_Customers". I want to use the"JobName" field's
"on click" event to open "frm_Specs" and have it filter out everything but the records relating to the "JobName" field. "JobID" is the
primary key. The wizard will set it up to open the form but I get anerror when I try to modify or create new records. The error message
says "Jet cannot find a record in the table 'tbl_Jobs' with key matching field(s) 'JobID' "
Click to expand...

Here's the code I'm using:

Private Sub Command54_Click()
On Error GoTo Err_Command54_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_Specs"

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

Exit_Command54_Click:
Exit Sub

Err_Command54_Click:
MsgBox Err.Description
Resume Exit_Command54_Click

End Sub
 
Back
Top