Displaying data on a form based off of a selection in a subform.

K

Kane

I am working on a database that has to deal with Attendance tracking. I have
a table setup that deals with scheduled hours and any incidences for them
records, as well as an employee table.

Likewise I have a form setup with 2 subforms (or rather a subform with
another subform in it). The main form has a department and a date field,
then the first subform has an employee detail where certain incidences can be
recorded to the Scheduled Hours Detail. The subform on there is a datasheet
view that contains a listing of employees and their scheduled hours for that
day and department.

What I would like to know is, is it possible to make it so that if you
select a record on the datasheet form, it appears on the employee incident
detail form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
filtering a form based on the values of a subform 0
Populate Form and subForms based on the user's selection from acombo box 10
How do I populate a subform field with a value from the main form? 4
Link two subforms in datasheet view (one sub-form, one sub-subform 1
form subform 0
Form/Subform - editing a record and I don't know why 2
main form based on table with no date field-need to tie-Sun dt w/s 2

Top