moke123

If you have time, will be nice to help me, I have attached sample db.
Send current Form record in Email body | Access World Forums (access-programmers.co.uk)

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

Hi mokel

Congratulations on VIP status. Well deserved