Select CASE using a combo box

[ndeeley]

Hi there,

I've not used Select Case statements, and as MS Access help is as much use as a chocolate teapot I thought I'd post my query here.

I have a combo box showing Task Summaries. When a particular one is selected I want Access to create a message box that a new tab is visible.

I can create the msgbox and show the tab, but how do I link it to the change in the combo option? Is a select ase statement on the AfterUpdate procedure the best - and if so, how do I create one?

Thanks!
Neil

[missinglinq]

Select Case is an excellent choice if there are going to be a large number of possibilities, as it clearly sets out each possibility and what action is to be taken. If there will only be a couple of possibilities, most people would simply use the If...Then construct. Here's an example of each for your situation, where Target Task is the selection you want to carry out actions for:.

Private Sub YourComboBox_AfterUpdate()
 If Me.YourComboBox = "Target Task" Then
  'Make new tab visible
  MsgBox "New Tab is Visible"
 End If
End Sub

Private Sub YourComboBox_AfterUpdate()
 
 Select Case YourComboBox
  Case "Target Task"
   'Make new tab visible
   MsgBox "New Tab is Visible"
 
  Case "Another Task"
   'Do something else here
 
  Case Else
    'Do something here when none of the above cases are valid
 
 End Select
 
End Sub
 

Linq ;0)>

[ndeeley]

Select Case is an excellent choice if there are going to be a large number of possibilities, as it clearly sets out each possibility and what action is to be taken. If there will only be a couple of possibilities, most people would simply use the If...Then construct. Here's an example of each for your situation, where Target Task is the selection you want to carry out actions for:.

Private Sub YourComboBox_AfterUpdate()
 If Me.YourComboBox = "Target Task" Then
  'Make new tab visible
  MsgBox "New Tab is Visible"
 End If
End Sub

Private Sub YourComboBox_AfterUpdate()
 
 Select Case YourComboBox
  Case "Target Task"
   'Make new tab visible
   MsgBox "New Tab is Visible"
 
  Case "Another Task"
   'Do something else here
 
  Case Else
    'Do something here when none of the above cases are valid
 
 End Select
 
End Sub
 

Linq ;0)>

Linq,

Fantastic - as ever!

Cheers
Neil

[missinglinq]

Glad we could help!

Linq ;0)>