Hi Experts,
My code does not work. It does not give any error message but simply ignores the WHERE parameter.
MembersTbl is an access table. Nom is a field of the table. ReportName is he name of a produced report. F01 is a string variable. V01 is also a sting variable. The WHERE clause is produced by a program which automates SQL production.
Help is highly appreciated.
My code does not work. It does not give any error message but simply ignores the WHERE parameter.
MembersTbl is an access table. Nom is a field of the table. ReportName is he name of a produced report. F01 is a string variable. V01 is also a sting variable. The WHERE clause is produced by a program which automates SQL production.
Code:
MembersTbl.NOM Like 'b*'
Code:
DoCmd.OpenReport [ReportName], acViewPreview, "F01 = #" & V01 & "#"
Help is highly appreciated.