report by form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form for filtering a report, but the independent pulldown field
called tagnumber querie bassed on a textfield, but the text for example
TT-1101 is trim to TT, shown because i have bin asked for a parameter, if i
fill in TT-1101 the report is show the correct field


stLinkCriteria3 = "[tbl General]![Tagnumber]=" & Me![Tagnumber]
stLinkCriteria = stLinkCriteria3
DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

I think something is wrong in the first line

Hugo
 
Not sure I understand your issue. However, if Tagnumber is text then you
will need to use:
stLinkCriteria3 = "[tbl General]![Tagnumber]=""" & Me![Tagnumber] & """"
 
Back
Top