Access Combox Question

[dewgan]

I have a form with a combox box where the list is populated via a linked table. This works fine. I have a text box that is filled with the name selected in the combox box. That name is then added to another table. That works fine. My problem is this, I want to keep the second table from being populated with the same name. So, for exampe, if I select the name John Smith in the Combo box but John Smith already exist in the second table, I want the process ended and a message to pop stating user already added. Does this make sense?

I'm kind of a vba newbie...so, I need a little help.

Thanks

[missinglinq]

This is untested but I think it'll do the job! You'll need to change the object names (NameComboBox, SecondTableNameField, YourSecondTable, and NameTextField) to match your own actual names.

Private Sub NameComboBox_AfterUpdate()
If DCount("[SecondTableNameField]", "YourSecondTable", "[SecondTableNameField]='" & Me![NameComboBox] & "'") < 1 Then
  Me.NameTextField = Me.NameComboBox
Else
  MsgBox "This Name Already Exisits in Second Table! Try again!"
End If
End Sub
 

Welcome to TheScripts!

Linq ;0)>