Date Range

[m17347047711116]

Situation Description:

i have entered my employee vacations using the following fields:

[AutoID] Number access assigns unique KEY
[Employee Number]
[First Name]
[Last Name]
[Vacation Date]

Problem:
A)
I would like to display all the records for a given employee on a single form for editing and viewing purposes but i do not know how to display multiple records on a single form. It would be nice if i could bring up the single form enter the employee Number and have the form show the employee details in the header and in the body show each date the employee is to be on vacation.

Please Help

B) Is there a better way

 

[David R]

Since you are still using Forms terminology here I'll refer you back to (one of) your original topics: http://www.access-programmers.co.uk/ubb/Forum4/HTML/005672.html

If you meant how to get a report to do a similar thing to a subform, you can actually include your subform as a 'subreport' to provide detail sections on your report. I use this and it works like a charm when we need to see details on the people in a neighborhood.

HTH,
David R

[This message has been edited by David R (edited 02-04-2002).]