Tie form field to second form

[dreamsoul620 via AccessMonster.com]

Hi,
I have a form that displays alerts for a user. A subform lists all the
alerts with a total number of violations for each name and the type of
warning that needs to be given to that person. Some of these require written
warnings. I have a button on my form that will take the user to another form
(the written warning memo). I want the user to be able to highlight the
correct record in the subform, hit the button, and the correct name will
populate into the memo automatically. I also want to requery the memo form
to pull in all violations based on the name that has populated from the other
form.

Example: Joni Stern and Steve Percy appear on my subform. Joni only needs a
verbal warning, so I can acknowledge and delete the warning. Steve needs a
written. I click a button and I'm taken to a form with his name
automatically in the Name field. There is an explanation as to why he is
receiving this warning and the standard operating procedure. Below this is a
section that lists every occurence and violation with date that has led to
this particular warning. This lets Steve know exactly what he has done wrong.
The person can then click print on this second form, and the memo is ready to
be signed and filed.

Any help is greatly appreciated.

Thanks,
Crystal

 

[dreamsoul620 via AccessMonster.com]

I finally figured this one out. Just in case anyone else wants to know.
I placed hidden text boxes on the first form that pulled the information from
the selected record in the subform. I then pulled the information from the
text box into the fields on my second form. By pulling the data into my main
form, I could then easily use it in the corresponding form. I tied the forms
together with a button so my query and form data stay with me as I move from
one to the other.