I have a combo box that retrieves its data from an access database using a SELECT sql command.
The combo box is part of a form with numerous other text boxes all used to add a new record into a table (named Teams) in my database - (the combo box is meant to act like an Access Lookup Box - holding values from a table named Countries).
Now, i hope you understand that part!! In access the combo box has a "not in list" event - I replicate this functionality by checking the value the user has entered in the combo box against the countries table in the database - if the value does not appear in this table it will ask the user if they want to add it and do so if the user chooses to. It then proceeds to add the record into the team table.
My question:
Is this the easiest way of replicating the Not In List functionality or does someone have any other - less code demanding ways of producing a "Not In List" event?
The combo box is part of a form with numerous other text boxes all used to add a new record into a table (named Teams) in my database - (the combo box is meant to act like an Access Lookup Box - holding values from a table named Countries).
Now, i hope you understand that part!! In access the combo box has a "not in list" event - I replicate this functionality by checking the value the user has entered in the combo box against the countries table in the database - if the value does not appear in this table it will ask the user if they want to add it and do so if the user chooses to. It then proceeds to add the record into the team table.
My question:
Is this the easiest way of replicating the Not In List functionality or does someone have any other - less code demanding ways of producing a "Not In List" event?
