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

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.

--
Steve Schapel, Microsoft Access MVP


"Mike read" <Mike (E-Mail Removed)> wrote in message
news:16513896-FCA0-463A-A629-(E-Mail Removed)...
> 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
>
>