Unanswered: Selection in a ComboBox determines Macro to Run
I have a comboBox that is being used to determine a record to work on. I would also like this combobox to determing what Access Macro to run. The Macro is going to control what form opens up. I tried to write some simple code but this was one thing I was never good at.
Any ideas or hints is appreciated as always!
Code is as follows:
Private Sub View_Record_Click()
On Error GoTo Err_View_Record_Click
If Me![ComboSelectProduct] = "PPO - Options PPO" Then
Dim stDocName As String
stDocName = "Macro - From Select to View"
If Me![ComboSelectProduct] = "PPO - Options PPO with Copay" Then
stDocName = "Macro - From Select to View 2"