Hi !
On my form I am opening a listbox onclick of a command button. Form recordsource is from a select query. In the listbox rowsource I have this:
SELECT tblWO.Status, tblWO.Property, tblWO.Asset FROM tblWO WHERE ((( tblWO.Status) Like [Forms]![FrmFilter]![FrmFilterCombo] & "*"));
This only returns the Status column and has all of the records instead of being filtered by FrmFilterCombo on the FrmFilter form. Where is my error?? I appreciate any help you can offer!!!
On my form I am opening a listbox onclick of a command button. Form recordsource is from a select query. In the listbox rowsource I have this:
SELECT tblWO.Status, tblWO.Property, tblWO.Asset FROM tblWO WHERE ((( tblWO.Status) Like [Forms]![FrmFilter]![FrmFilterCombo] & "*"));
This only returns the Status column and has all of the records instead of being filtered by FrmFilterCombo on the FrmFilter form. Where is my error?? I appreciate any help you can offer!!!
Last edited: