How can I link two forms together

  • Thread starter Thread starter jhanby1
  • Start date Start date
J

jhanby1

So my problem is this...I have one table (fsubCaseSearch) that contains
a listbox of all cases. I need to be able to double click the list, and
have another form (fsubCaseDetails) popup that contains all the
information about that specific case. I have all the forms set up
correctly, I just need to know how to link this information. I have
some code from the previous version of this DB, and it works on the old
one but not this one. I think I need to pass the linking value in
fsubCaseSearchto fsubCaseDetails through a filter, but I'm not sure how
to do this or if its even correct. Here is this code I have so far for
double clicking a particular case in the list box:

Private Sub lstCases_DblClick(Cancel As Integer)

Dim ctlList As Control, varItem As Variant

Set ctlList = Forms!frmMainPage!fsubCaseSearch!lstCases

DoCmd.OpenForm "frmMainPage2", , , "tblCasesID = " & ctlList

End Sub

I know the referencing is correct, b/c it does pull up the right case
number from fsubCaseSearch, but it just doesn't pass it along to
fsubCaseDetails.

Anyone got any BRIGHT ideas!??!??
 
I would have the second form using a query as record source and criteria in
the query from the listbox in the first form.
 
Back
Top