Using a variable with DoCmd.ApplyFilter (1 Viewer)

[Howie Jones]

Hi again

I want to replicate the 'Filter by selection' menu functionality in VBA to filter to the current record only.

DoCmd.ApplyFilter appears to only accept text as the = part of the argument.

If I Dim and set a variable CurRec to = SCOFull (a serial number that is unique to a given record)

DoCmd.ApplyFilter , SCOfull = CurRec - filters to include all of the records

DoCmd.ApplyFilter , "SCOfull = CurRec" - thinks CurRec is an undefined variable and pops up a dialogue box for you to type it in.

DoCmd.ApplyFilter , "SCOfull = 'CurRec'" - filters to a new record

What am I doing wrong? Or does DoCmd.ApplyFilter only work with a string input?

Regards

Howie

 

[namliam]

if its a number:

"SCOfull = "& CurRec

If its text:

"SCOfull = '"& CurRec & "'"

Regards

 

[SilentBreaker]

Or

If its text:

"SCOfull = " & Chr(34) & CurRec & Chr(34)

 

[Howie Jones]

Excellent, worked first time.

Howie