A
amandy
I know that I am not the first to ask about auto-filling forms, but I
have tried many examples that I've found and none of them have seemed
to work.
I'm working with Access as part of a class project, and I've never
worked with it before. While I have programming experience, I have very
little knowledge of VB.
I have two tables in my Access Database; one is of Students, and one is
of Employers. I want to keep track of information about contact that I
have made with students or with employers. I have two forms; one for
each table, that will allow input of the student/employer information,
and the details of the contact that was made with them.
I want to be able to type the student's school ID number into the form,
and IF there is another record in the database matching that ID number
(which is only part of the primary key), I want to pull the student's
contact information and fill in the form. I want to do the same with
the employer's contact information on the employer form. If there isn't
already an entry into the database for that student id or that
employer, then the information will be entered for the first time.
All of the help that I have found on the matter seems to fill in the
forms based on the very previous entry, or it gives me some sort of
error, or it simply doesn't fill in the fields. Can someone help me
out, or point me in the direction of an answer that is out there that I
have missed?
Thanks in advance,
Mandy
have tried many examples that I've found and none of them have seemed
to work.
I'm working with Access as part of a class project, and I've never
worked with it before. While I have programming experience, I have very
little knowledge of VB.
I have two tables in my Access Database; one is of Students, and one is
of Employers. I want to keep track of information about contact that I
have made with students or with employers. I have two forms; one for
each table, that will allow input of the student/employer information,
and the details of the contact that was made with them.
I want to be able to type the student's school ID number into the form,
and IF there is another record in the database matching that ID number
(which is only part of the primary key), I want to pull the student's
contact information and fill in the form. I want to do the same with
the employer's contact information on the employer form. If there isn't
already an entry into the database for that student id or that
employer, then the information will be entered for the first time.
All of the help that I have found on the matter seems to fill in the
forms based on the very previous entry, or it gives me some sort of
error, or it simply doesn't fill in the fields. Can someone help me
out, or point me in the direction of an answer that is out there that I
have missed?
Thanks in advance,
Mandy