UK Bank Sort Codes

[Guest]

I trying to get a way of being able to recognise banks by tying in there sort
codes in a form...

The trouble I am having... I do not have a full list of bank codes... but
some banks you can recognise from the first two numbers i.e. 01 is natwest...
but some are from first four numbers i.e. 09-00 is Abbey and then there are
the ones that get recognised from all six and a lot of numbers... i.e.
12-60-00 to 12-69-99 are all used by Sainsbury...

I have most of the banks... but I can manage the list if this is possible...
if someone trys to enter a sort code that is not in the list... give the
user the ability to add new bank details...

Regards - Paul

 

[John W. Vinson]

I have most of the banks... but I can manage the list if this is possible...
if someone trys to enter a sort code that is not in the list... give the
user the ability to add new bank details...

Take a look at the "Not In List" event of a Combo box. If you have a Combo on
your form bound to your banks table, the user can type a bank code into the
list; if it's there it will find it, if not the Not In List event will fire
and you can use it to add a new record to the banks table.

John W. Vinson [MVP]