Stumped!!

  • Thread starter Thread starter Guest
  • Start date Start date
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??
 
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)
 
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
 
You must log in or register to reply here.

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

Help With MS Access 4
Adding a lookup list to further filter form results 1
combo box selection will not populate query correctly 1
Access Cannot select items in listbox 1
selecting multiple values on list box 2
Combo box Subform Control Default 2
Copying List box values/selection to a database of sorts 2
Data in list boxes disappears when form refreshed 3

Back
Top