View Single Post
  #5  
Old October 12th, 2005, 11:29 PM
Chris
external usenet poster
 
Posts: n/a
Default

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