I'm working on an Access database and have a form with a combo box (a list of assembly plant locations), and I want a command button that will open the layout file for that plant.
I've got
Application.FollowHyperlink "<file location>"
which works, but I'm looking for a way to control what file is opened based on the selection in the combobox.
I tried
If ([Combo154]="<plant name1> Then
Else
If ([Combo154]="<plant name1> Then
Etc...
I also tried
If Combo154.Text.Contains("<Plant name>" Then
Etc
However both of those just made the command button do nothing (didn't even return error code)
Any suggestions?