Code to open a form

[UT227]

I'm looking to add an IF statement and not sure how to go about it. I have a form, [frmEmployees]. I need it to open another form [frmEmergencyContact]. However, I need it to open the form to a new entry if there isn't already one there. If there is already a record for that employee, I need it to open the form for that employee. The primary key is [EmployeesID]. I'm not sure how to do it.

[ranman256]

if viewing a list of employees (continuous form), select the record then open the detail form using the ID in the text box (me.EmployeesID)

docmd.openform "frmEmployees",,,"[EmployeesID]=" & me.EmployeesID

the emergency contact should be a subform in the detail form: frmEmployees. (no need for popups )
you will SEE that its empty, and can just add as many contacts as you need.

but if you need a popup form, you can open another form using the same method above to open ONLY that employees ID:
docmd.openform "frmEmpContacts",,,"[EmployeesID]=" & me.EmployeesID

[UT227]

Thanks. That seemed to do it.