What's new

Latest profile posts

Thank you MajP for your Date Picker selection. I'm a real novice a Access VBA but learning a bit more every day, your instructions are perfect and they got me out of a hole. Much appreciated.(y)
Thank you for helping me most of the time. I posted a question, may be if you have time to help out in this post.
Hi @arnelgp , thank you for helping me most of the times. I posted question, may be if you have time to help me out there..

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
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
Top Bottom