Vlookup list to report Y/N? is it possible?

[batman1056]

I have an excel file with a Vlookup, and it basically looks at 3 lists of post codes and reports if the post code entered is equal to one on the list.

I am now creating a client database and would like it to do the following
when I put the clients post code in - it will automatically check to see if the post code is part of list A,B,C and in form it will show

Eligibility Areas A (result Yes if the post code is in list)
Area B etc.
Area C etc.

 

[Dennisk]

The easiest solution is to import the post code data from excel into Access. You may or may not need to add a field to each table for the area grouping (Infact you could probally merge all 3 tables together). Then all you need is a combo box for the field.

 

[batman1056]

Importing over 9000 postcodes is not a problem, but listing them on a combo will not do what I want.

I would like to be able to input my own postcode (not from the list) and then if its in any of the lists it will automatically update a field to say that the post code input is in area 1 and area 2 but not in area 3 or 5

Combos will not do this. my vlookup is great in excel, just need somthing like it in Access