Combo Box ?

[jeremy0028]

I have a combo box called Primary which has Yes/NO

I have a Text Box called Text50

If user selects Yes From the combo box then the Text Box will show P
If user selects No From the Combo Box then the Text Box will show S


Any Ideas

 

[fneily]

On the AfterUpdate event of the combobox put:

Private Sub Primary_AfterUpdate()
If Me![Primary].Value = "yes" Then Me![Text50].Value = "P"
If Me![Primary].Value = "no" Then Me![Text50].Value = "S"
End Sub

 

[jeremy0028]

Thanks