open a form to a new record for a specific employee

[kelkan]

I have 3 tables: tblEmployees, tblCourses, and tblTraining. I have a form to schedule training for employees called FORMSCHEDULE that is based on a query called QUERYSCHEDULECLASSES. The form has the following fields:
TRAININGID (PK in tblTraining)
EMPLOYEEID (FK in tblTraining)
EMPLOYEENAME (calculated last and first name field from tblEmployees)
COURSEID (FK in tblTraining)
cboCourse (combo field to tblCourses)

I want to open the form to a new record in tblTraining for a specific employee in another form. Right now, I have a command button on the other form (frmEmployeeList) that opens this form. I have the query for FORMSCHEDULE (QUERYSCHEDULE CLASSES) criteria set under EMPLOYEEID like this: [EMPLOYEEID]=[forms]![FrmEmployeeList]![EMPLOYEEID]

I can get the form to open to the specific employee I want, but it shows an existing training class already entered in tblTraining.


I tried to set TRAININGID criteria to Is Null but I get nothing in any field on the form (FORMSCHEDULE).

How do I create a new record in tblTraining for a specific employee and open the form to a new TRAININGID for that specific employee?

[June7]

You want to open Training form to a new record and populate the EmployeeID of that new record?

Have you considered a form/subform arrangement instead?

This is one reason I don't use parameterized queries, too restrictive. Instead, I use WHERE CONDITION of DoCmd.OpenForm.

Behind button to open existing record:
DoCmd.OpenForm "formname", , , "EmployeeID=" & Me.EmployeeID

Behind button to open new record, use OpenArgs to pass EmployeeID:
DoCmd.OpenForm "formname", , , , acFormAdd, , Me.EmployeeID

Then code in training form Current event:
If Me.NewRecord Then Me.EmployeeID = Me.OpenArgs