filtering of combo box / vba code

[Kotoca]

Hi

I'm pretty new to access programming, and after hours of search I still haven't come up with a proper solution. I'd greatly appreciate some help!

Goal of my Database: Recording bank transaction (money transfers from one account to another)
Details: On the form on which I record these transaction I have two combo-boxes: 1)Account Debited and 2)Account Credited.
Both combo-boxes have the same source, which is the Active-Account-Table.

Unsolved Problem: After selecting an account number for the "Account Debited" I don't want this account number to reappear in the combo box of "Account Credited", as this account number has to be different than the one chosen in "Account Debited".




Could anyone help me with that? It will be greatly appreciated!

[alansidman]

In the afterupdate event for the second combo box insert this code:

Private Sub YourField_AfterUpdate()
If Me.2ndComboBoxName = Me.1stComboBoxName Then
MsgBox ("Change your Credit Account.")
Me.2ndComboBoxName = Null
Me.1stComboBosName.SetFocus
End If

End Sub

Change the field names to match what you have in your form.

[Kotoca]

Thank you very much for your help.

That was just what I needed. It works perfectly.

Thanks again.