hiii ....can you help me to filter listbox by command button then search by textbox
listbox datasource based on query and used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" on testname
but
button1 on click List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
button2 on click List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
when i click button 1 .....listbox nolonger filtered by text search box
listbox datasource based on query and used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" on testname
but
button1 on click List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
button2 on click List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
when i click button 1 .....listbox nolonger filtered by text search box