G
Guest
How can I run a macro only after a specific value is picked from a list of
values within a list box on a form??
values within a list box on a form??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
If you're using VBA, you can put logic in the listbox's AfterUpdate event to
check what value has been selected, and only run the code if the appropriate
value's been selected.
If you are using a macro, I believe you can refer to the specific control in
a condition, and check its value (sorry, I never use macros...VBA is far
more flexible)
check what value has been selected, and only run the code if the appropriate
value's been selected.
If you are using a macro, I believe you can refer to the specific control in
a condition, and check its value (sorry, I never use macros...VBA is far
more flexible)
G
Guest
In a macro, you can open the "condition" column from the tool bar. Then your
condition would be Forms![formname]![controlname] = whatever you need to
condition would be Forms![formname]![controlname] = whatever you need to
S
Steve Schapel
.... or simply
[controlname] = whatever
[controlname] = whatever