Combo Box and Vb Code Help.

[Rgsjr]

Hello,
I am currently in a project using MS Access 7.0 , here is the situation;

1. The main form I am working with is “frmAccountEntryMain”.

2. The account number is selected by combo box pulling from a secondary table not attached or related to the main table on which “frmAccountEntryMain” is based (number series from 00001-99999).

3. The Query the combo box is pulling from is “qryAccountList”*
*Criteria: List only those accounts that are classified as “No”.

4. The Table “tblAccountList” on which “qryAccountList” is based has two fields;
1. AccountID
2. Assigned**

**The idea was to have the Assigned field default be “No” and update to “Yes” after it was assigned. The person entering information on “frmAccountEntryMain” would choose an account number. When they added the next account number the previous number would not be available.

Q: After selecting an account number, what can I use to change the assigned field for this account number from “No” to “Yes”?

Any Help would be appreciated.

 

[lameid]

On the form's After Update event, check to see if information has been entered for the account. If it has, set assigned to true.