" you have already choose B!"

[gwidijanto]

Hi all,

I have a combobox with "A, B, C" choice for inputing field named: [function].
If in that field already contain a record with "B" and I choose "B" again from the combobox, how to set a warning message, something like this: " you have already choose B!"

Thankyou in advance for you help.

Gunawan.

Note:
control source for combobox is: [function] field.
row source for combo box is from another table with field contains: "A, B, C"

 

[Jack Cowley]

If Me.ControlName = Me.ComboBoxName Then
MsgBox "You have already selected " & Me.ControlName
End If

ControlName is the name of the control on your form that has the value that you want to enter from the combo box. Also note that 'function' is a reserved word in Access and you should not use it as you are.

hth,
Jack