Action Combo Boxes - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Action Combo Boxes

James Hopkins

5 years ago

Hey Richard, I am trying to create a "Choose Action" Combo Box that I can select the Action to preform. So, is there a way to write an 'Global Module', that have all the Functions Listed, to use when I have multiple Forms that or do I have to write an individual 'VBA Code' for each Form? Please Help...

	Adam Schwanz @Reply 5 years ago
I would think you could just send it to the combobox. Make a global module Public Function ComboBox (X As String) If X = "Action1" Then 'Do Action1 if X = "Action2" Then 'Do Action2 End If Then in the button or on change event, whatever you're using to trigger it, do Combobox(InsertTheComboBoxNameHere)

	James Hopkins OP @Reply 5 years ago
Thank you, I will try this.

	Adam Schwanz @Reply 5 years ago
You might need to do Combobox(InsertTheComboBoxNamehere.Value) and you might need to be aware of the bound column in that combo box it might send the ID field if that's the bound field.

	Richard Rost @Reply 5 years ago
Kinda like my Report Listbox

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View