Filtering in a form

  • Thread starter Thread starter SMiller
  • Start date Start date
S

SMiller

I'm opening a form and setting the filter as follows:

DoCmd.OpenForm "SalesbyProductDetailedForm", , ,
"[SalesbyProductDetailedForm]![ProductCode] = '" & Me!
[ProductCode] & "'"

However, this command
gives me a space infront of the Me![ProductCode] value,
thus creating the filter to fail.

How do I get rid of it

Thanks
 
Back
Top