can i use a macro with a comand button to aply a filter to a list

M

Mike read

i have a data base that i am filtering with several different applyfilter
macos in comand buttons. they all work well to limit the records but it has
no effect on the list box i have to select records using an alpha list.


is their a way to change and or add a macro to those comand buttons so it
takes affect on the list box aswell
 
S

Steve Schapel

Mike,

If I understand you correctly, you would I think need to use a SetValue or
SetProperty action in your macro, to change the RowSource property of the
Listbox.
You may also need a Requery action applied to the listbox, following the
SetValue.
 

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

Similar Threads

Filter from Combo Box Value List 1
Use Macro to Filter records in Subform on open 0
VBA: How can I use a string variable as autofilter criteria? 4
help me filter a form using VBA 0
options on list box conditional on whats entered in another contro 2
adding a control button with a filter 2
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Access 2007 Apply Filter Macro Conditions 0

Top