Again, thanks.
A button on [frmEmployeeSetup] is how the user closes [frmEmployeeSetup]:
Me.Inactive = False ' sets the employee to active
Dim frm As Form
Set frm = Forms![frmEmployee]
frm.[cboSelectEmployee].Requery '[frmEmployee] combo box which contains
"EmployeeID" for all active employees.
frm.Requery
With frm.RecordsetClone
.FindFirst "EmployeeID=""" & Me.EmployeeID & """"
If Not .NoMatch Then frm.Bookmark = .Bookmark
End With
Set frm = Nothing
DoCmd.Close acForm, "frmEmployeeSetup"
Yes, the record exists when [frmEmployeeSetup] opens. But I don't use
"where", I use OpenArgs via a popup (from an MVP a while back) that uses
NotInList Event of a combo box to create and write the record before opening
[frmEmployeeSetup]. That combo box is all that's on that form; updating the
combo box passes open args to [frmEmployeeSetup].
And...yes, the record is setup, when I close [frmEmployeeSetup] and, yes,
that's the record I want to view.
I know this will work if I can solve why [frmEmployee] vanishes.
--
Thanks for your help,
Chris
|