I have a mainform/subform. On teh subform next to the record is an edit button that does call another form for a particular record and works find. But I want to close this first form in the code, but since it is on the sub-form, it does not close the entire form at all.
DoCmd.OpenForm "frmEmployees", , , "[EmpUserID]= '" & strUserID & "' " -THIS WORKS
DoCmd.Close acForm, Me.Parent.frmEmpsNoJobID - THIS DOES NOT
The main form is called frmUnmatchedEmpoyees. This is an Access 2003 form.