K
Kirsty
Hi everyone
I need some help with something that should be simple
(and most probably is).
I have one table with the telephone numbers and details
of my clients. The table is indexed(no duplicates) on
the tel# field.
My problem:
As I enter a new client, I want the form to autofill if
the record exists and call up the client info, and if it
does not exist then call up a blank record and at the
same time insert the new tel# in the correct field.
Please help.
Kirsty.
I need some help with something that should be simple
(and most probably is).
I have one table with the telephone numbers and details
of my clients. The table is indexed(no duplicates) on
the tel# field.
My problem:
As I enter a new client, I want the form to autofill if
the record exists and call up the client info, and if it
does not exist then call up a blank record and at the
same time insert the new tel# in the correct field.
Please help.
Kirsty.