Filtering Continueous Forms 1

[dendic]

I'm attempting to use this code but can't get it to work.
Dim varConsignee as string
varConsignee = Me.Combo15
DoCmd.ApplyFilter , "Consigneename = varConsignee"

I also tried.
Me.Filter = "Consigneename = varconsignee"
Me.FilterOn = True

 

[CautionMP]

dendic,

Me.Filter = "Consigneename = '" & varconsignee & "'"
Me.FilterOn = True

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[CautionMP]

or if your into built in functions

Me.Filter = BuildCriteria("Consigneename", dbText, "=" & varConsignee)

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[dendic]

I have one more problem when varcConsignee has a period in the name I get an error about "invalid Dot or invalid ! or invalid parenthesis".

 

[PHV]

Perhaps this ?
Me.Filter = "Consigneename = [tt]'"[/tt] & Replace(varconsignee, [tt]"'", "''") & "'"[/tt]
Me .FilterOn = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886