Command button will not appear when I make a selection from a drop down

[John_G]

I have highlighted the mistake in red:

Private Sub SiteSelect_AfterUpdate()
Me![Address] = Me.SiteSelect.Column(2)
Me![AssignedTechs] = Me.SiteSelect.Column(3)
If Me.SiteSelect = "Brandon, MB" Then
Me.Dispatch2.Visible = True
Else
Me.Dispatch2.Visible = False
End If

That is referencing the first column, site ID. To reference the second column, contaning the text value, use Me.SiteSelect.Column(1)

[tobydobo]

Awesome! I knew it would be something simple like that. You da man!

[tobydobo]

I have highlighted the mistake in red:

Private Sub SiteSelect_AfterUpdate()
Me![Address] = Me.SiteSelect.Column(2)
Me![AssignedTechs] = Me.SiteSelect.Column(3)
If Me.SiteSelect = "Brandon, MB" Then
Me.Dispatch2.Visible = True
Else
Me.Dispatch2.Visible = False
End If

That is referencing the first column, site ID. To reference the second column, contaning the text value, use Me.SiteSelect.Column(1)

I am trying to add one more variable to the code above to where the same trigger happens when 2 items are selected from a dropdown. I tried listing them separately but it doesn't work:
If Me.SiteSelect.Column(1) = "Brandon, MB" Then
Me.Dispatch2.Visible = True
Me.Dispatch1.Visible = False
Else
Me.Dispatch2.Visible = False
Me.Dispatch1.Visible = True
End If
If Me.SiteSelect.Column(1) = "Linwood, MB" Then
Me.Dispatch2.Visible = True
Me.Dispatch1.Visible = False
Else
Me.Dispatch2.Visible = False
Me.Dispatch1.Visible = True
End If

[ItsMe]

You can only make one selection from a combobox control.

[tobydobo]

Im not tying to select 2 things from the drop down I'm trying create a trigger based on two different selections in a drop down. Is ther an OR or a wildcard ( ex: *MB since both options have MB in them) statement perhaps that will trigger the same event if either options are selected from the drop down?

[ItsMe]

Something like this might work ...

If Me.SiteSelect.Column(1) = "Brandon, MB" Or Me.SiteSelect.Column(1) = "Linwood, MB" Then
Me.Dispatch2.Visible = True
Me.Dispatch1.Visible = False
Else
Me.Dispatch2.Visible = False
Me.Dispatch1.Visible = True
End If

[tobydobo]

I tried that actually before I posted. For some reason it doesnt like the OR statement in that syntax. Any other suggestions?

[John_G]

That IF statement should work - the syntax is fine. What was the error message?

Can you post the code that is giving you an error?