How To put the Control on A Row in Subform

[Denise Blum via AccessMonster.com]

I have a main form (in single form view) that shows only certain records
from the employee_tbl. I created a subform in (datasheet view )to show or
list all records from the employee_tbl. I saved the subform, then I
dragged and dropped the subform onto the bottom (detail portion)of my main
form.

I want to be able to see the list of all records on the subform, then click
on the row in the subform and have certain records from the row displayed
above on the main form.

Is this possible. Does anyone have a solution? Thanks!

 

[Steve Schroeder]

It is possible.

The tricky part is referencing the form/subform controls and fields. Most of
your code will reside in the Enter or Click event of the fields in the
subform...copying the data from the suborm field to the main form field.

Think about how it makes most sense to lay this all out. Keep it as simple
as possible. For you and the users, lol