Open new form based on Filter Form

[twalsh]

Ok so i have a filter form i found on allenbrowne.com/ser-62.htm, i modified
it for use with my database and works fine.

My next step is a little more elaborate...
I want to click on one of the text fields in the Continuous form to open a
NEW form that will contain just that record as well as subforms to alter data
attached to that record.

I am new to this whole SQL coding thing so go easy on me plz

 

[Damon Heron]

I use the double-click event to open a new form with the same record number
as my source field.

Private Sub WO_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = Me!WO 'this is the work order # on the current summary
form
stDocName = "frmWorkOrders" 'this is the form I want to open
DoCmd.openform stDocName, , , "WOID = " & stLinkCriteria 'WOID is the ID
of the workorder form's record
End Sub

Damon

 

[twalsh]

Ok, i think this is where i want to go but I have a few questions.

what type of control are you (double)clicking on?

stDocName and stLinkCriteria, are those SQL terms or something i need to
change in my database?