Lookup keyed field data in past record and display a flag of sorts

SpirituaLee

Registered User.
Local time
Today, 11:41
Joined
Dec 5, 2007
Messages
16
Access 2003.

One of the fields on my form is there to accomodate a client postcode (zip code) [Post_code].

What I need...

I'd like the data keyed to be looked up in all previous records to see if the postcode has been keyed previously.

If it has, I want an unbound check-box field [Previously_keyed] to be checked accordingly, or more ideally I'd like a link to appear, linking to the previous records containing that Postal Code.

Your clevernesses and intelligences are most appreciated!
 

Users who are viewing this thread

Back
Top Bottom