On my form the User needs to input a new Job_Reference (typically something like SMI09_1) where the SMI is the client code, 09 the year and the _1 the reference number for that year. As the user can't necessariy know the clients last reference number I want the form to show a message if a similar Job_Reference exists (primary key) so a new number can be inputted. (As the job_reference is the PK Microsoft displays its default message but I want to put something more user friendly there). Ideally I would also like to show any records that are similar to that clients code. Any suggestions please?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Check if record exists and then advise user
- Thread starter mondeoman
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question