I am about to try those suggestions... But what about getting the main form
to display the information that the user typed in such as the Employee Name,
the Vacation Start Date and the Vacation End date in the main form. I have
gotten the records to show in the datasheet. For example:

QUESTION USER ENTERS
What is the emplouee name John Allen
Vacation Start Date Jan-3-2005
Vaction End Date Jan-6-2005

How would I get the information to display this in the main form:

Employee Name: John Allen
Vacation Start Date: Jan 3 2005
Vacation End Date: Jan 6 2005

Is there a way that I can recall what the user entered in and assigned those
values to text boxes in my form? Keep in mind that the promts come from the
subform that displays the filtered information. Can anyone help me with this?