I am trying to refresh datasheet records as i type anything in the text box. (i.e. as i type each letter in a text box i would like the datasheet to be refreshed accordingly).
So, to do that i wrote the query below :
Expand|Select|Wrap|Line Numbers
- SELECT employee.surname, employee.firstname, employee.department
- FROM employee
- WHERE (((employee.surname) Like "*" & [forms]![KPI Manager]![txtLastName] & "*"));
My datasheet is reading data from the query above.
In VBA editor i wrote the query below :
Expand|Select|Wrap|Line Numbers
- Private Sub txtLastName_Change()
- Forms![KPI Manager].Form!KPIManager1.Form.Requery
- Forms![KPI Manager].Form!KPIManager1.Form.Refresh
- End Sub
Any help would be greatly appreciated.
Thanks
Rashed