OpenForm Where Clause 1

[LakotaMan]

Hi All,

I am having some trouble with my OpenForm Where clause. I am using version 2003 and have a form with a client record on it. Need to get the Client Cases from another form, so have set up this code:

    DoCmd.OpenForm "frmClientCaseList", acNormal, , Forms![frmClientCaseList].[lngClientID] = Me.lngClientID

What have I overlooked? (I know, probably something obvious)!


Thanks for all your help,
LM

 

[MajP]

it has to be a string.
"lngClientID = " & Me.lngClientID

 

[PHV]

Why not simply use a linked subform ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LakotaMan]

MajP: Thank you, that got me exactly what I needed!

PHV: Am chagrined to admit I don't think I've worked with linked subforms.