Buttons and Listboxes

I need to set up a number of buttons each having a different value to
them. I want to click on any given button and that in turn would
requery a listbox on a form according to that buttons value. How could
this be done.
Thanks
DS

re: Buttons and Listboxes

You can cast a value on the end of the button name and use that as the
parameter value for the requery. Let's say you have btn1 and btn2. When
btn1 is clicked you use the parameter value Right(btn1.Name,1) to a
function or sub routine. That way each button calls the same function
just passing a different parameter.

good luck.
mike

re: Buttons and Listboxes

mik18@pitt.edu wrote:[color=blue]
> You can cast a value on the end of the button name and use that as the
> parameter value for the requery. Let's say you have btn1 and btn2. When
> btn1 is clicked you use the parameter value Right(btn1.Name,1) to a
> function or sub routine. That way each button calls the same function
> just passing a different parameter.
>
> good luck.
> mike
>[/color]
Thanks I'll give it a try.
DS