Way To Hold Value From Field For Another Form

OK,
I have a form, that allows the users to enter time off for staff. It has a start date and end date fields. When they hit submit, it will enter records for all the days within this timespan into the table.

Here is the code I have on my button onclick

StartD = txtbegdate.Value
EndD = txtenddate.Value
FN = cboEmployeeName.Value
RC = cboReasonCode.Value
TM = txtteam.Value
TC = cboComments.Value
For Counter = StartD To EndD Step 1
txtbegdate.Value = Counter
Datefound = Nz(DLookup("[ExcludedDates]", "qryDateExcluded"), 0)

If Datefound = 0 Then

'Found no excluded date
txtDateOff.Value = Counter
cboEmployeeName.Value = FN
cboReasonCode.Value = RC
txtteam.Value = TM
cboComments.Value = TC
DoCmd.GoToRecord , , acNewRec
End If

Next Counter
txtbegdate.Value = ""
txtenddate.Value = ""
MsgBox "Dates added, click OK to continue!", vbOKOnly
End Sub

What I want to do next is, after it enters the data. It popups another form, that is based on a query that checks for duplicate entries for that person.

I thought using something like this right after the msg box alert, would do the trick.


Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "f_findduplicates"

stLinkCriteria = "[Employee_Name]=" & "'" & Me![Text0] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

but, what happens is after the data is entered. The main form clears so the user can make the next entry. So when the popup form is generated, there is no 'employee_name' data to base the query on. so the form opens blank.

Is there a way to keep the 'employee_name' field data in a temp memory or something so the form has something to run with?

Or does anyone have a better solution? I would prefer that the data never gets entered in the first place, but I can't get anything like that to work with my current form.

thanks in advance.
Chris