Hello,
I am trying to filter a query using a textbox on a loaded form and I am using following SQL but it is not working.
I am using this query on a subform and using me.SubFormControlName.requery in on change and after update event to filter the results. I want to implement search option so that user can search any text in the report title. Please help.
Best Regards,
Abdullah
I am trying to filter a query using a textbox on a loaded form and I am using following SQL but it is not working.
SQL:
SELECT tblReports.*, tblReports.ReportTitle
FROM tblReports
WHERE (((tblReports.ReportTitle) Like '* & Forms![frmSearchReport]![ReportTitle] & *'));
I am using this query on a subform and using me.SubFormControlName.requery in on change and after update event to filter the results. I want to implement search option so that user can search any text in the report title. Please help.
Best Regards,
Abdullah