list box filter toggle button

L

lmv

I have a listbox (List34) that I want to be able have a toggle button to turn
off/on the "inactive" filter at present it is set to following criteria.

SELECT [Name List].ID, [Name List].TID, [Name List].LastName, [Name
List].FirstName, [Name List].Status
FROM [Name List]
WHERE ((([Name List].Inactive)=False))
ORDER BY [Name List].LastName, [Name List].FirstName

can someone direct me to an example to download or what code to put in
the clk event of a button. Also, I will need to requery the List34 right?

I did this once upon a time but can't remember how now.
That's the problem with not working on a project all the time.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top