Lookup Values of field from table

[hullstorage]

i have a table which have all of the UK Postcodes in it
PostcodeID, Postcode,Street, Town, County.

What i am trying to do is after i have enter a postcode in a form field is for it to look for the results in th postcode table

I know i can use a query but this would mean creating about 6 different queries for each task, is there a simpler way of doing this

thanks

 

[MStef]

Look at "DemoComboB3A2000.mdb" (attachment, zip).
I think you need something like this.