Return result from form

[Guest]

Hi

I have the following 2 tables Employees containg names, dob, and ref, and
course evaluation containing only ref and course evalution details. Both of
these tables have forms for entering data.

What i would like to do is on the evalution form have a button that when
pressed opens a form with just name and ref. This i can do. But then when the
correct ref is found another button copies the ref to the evaluation form.

All help is appreciated.

 

[John W. Vinson]

Hi

I have the following 2 tables Employees containg names, dob, and ref, and
course evaluation containing only ref and course evalution details. Both of
these tables have forms for entering data.

What i would like to do is on the evalution form have a button that when
pressed opens a form with just name and ref. This i can do. But then when the
correct ref is found another button copies the ref to the evaluation form.

All help is appreciated.

Make the course evaluation form a Subform of the employee form, and use ref as
the master/child link field. It will synchronize automatically, with no
button, no code, and no hassles!

John W. Vinson [MVP]