Hi James
I've only just picked up on this thread and see you are also UK based.
For info I have several UK postcode applications both free and commercial which may be of help (see below)
Many UK addresses don't have a house number or have text equivalents e.g 24A or Flat 14.
How would you manage situations like that?
I see you are already receiving expert help from several forum members so I'll largely refrain from adding further code suggestions at this point.
However, I've looked at both your database from post #24 and Bob's from post #28.
Just wondering whether you could use a modified version of Bob's approach but using a combo for postcode and adding a house name field as well as house number (or combining both using a text field for name or number).
If you use a combo for postcode, you can add NotInList event code to look up addresses for the entered postcode.
For this you may be able to use/adapt my Postcode Address Lookup app
http://www.mendipdatasystems.co.uk/u...kup/4594767232
The app is free if you want to try it (with source code available at a low cost).
It is a cut down version of my commercial app available at
http://www.mendipdatasystems.co.uk/u...der/4594138311