Expression Builder

[Yusuf]

Hi

I'm new to Access and trying to amend a form's text boxes by the month selected in my combo box

In the cmbMth combo box, I have all the months in Row Source.
Txtbox1 is =[cmbMth] which is fine

Txtbox2 should return Txtbox1 + 1
In other words, if I drop down and select "January" in the cmbMth then Txtbox2 should return "February"

Can this be done in the Control Sourse property's expression builder?

Many thanks
Yusuf

[geekgirlau]

Private Sub cboMonth_AfterUpdate()
If Me.cboMonth.ListIndex = 11 Then
Me.txtBox2 = Me.cboMonth.ItemData(0)
Else
Me.txtBox2 = Me.cboMonth.ItemData(Me.cboMonth.ListIndex + 1)
End If
End Sub

[matthewspatrick]

What happens when the user selects December in the combobox?

[geekgirlau]

That's what the IF statement looks for - if the index number is 11 (i.e. the 12th item, December) it reverts to January.

[matthewspatrick]

Ah, I see it now :doh: