I have this form with cboBankType.
The form is Continous Forms with underlying table : tblBanks_Participating
ID = BankEnterID
I want to limit a users input on this cboBankType to only 1 occurence of a "Initial Issuing Bank" (the ID is =1 on this BankType)...meaning that there can only be 1 "Initial Issuing Bank".
When creating records, How can I limit a duplicate entry on cboBankType for only when the cboBankType ID is =1 which corresponds to "Initial Issuing Bank"? (this means that the previous record has this banktype description already)...
cboBankType [BankType field name] has this as a row source:
SELECT tblBankType_dropbox.BankTypeID, tblBankType_dropbox.BankType FROM tblBankType_dropbox ORDER BY tblBankType_dropbox.BankTypeID;
Please ask if you have questions. I am thinking that possibly there is some type of Validation rule you can setup or something pretty simple to limit to only one "Iniital Issuing Bank".