Pleezz Help! Run-time error when copying between forms

Please help a access beginner!!

I have 2 forms, the form1 has an staff_id field on it and a customer id. I enter the staff_id then the customer id, then press the button I made which brings up the new form2 which has staff_id, customer id and customer name on it. They are both bound to seperate tables, table1 with staff_id and customer id and table2 with staff_id, customer id and customer name.

I want to be able to type the customer id and staff_id on form1, press the button to bring up form2 matching the customer_id, and have access assign the empl_no. to the staff_id field on this table.

The button simply displays form2 matching the customer no., this part works. Its when I tried to make make the staff_id automatically appear on form2 I get the Run-time error '424' Object required.

I have the following on form2 to try and copy the staff_id

Private Sub Form_Load()
form2.staff_id = form1.staff_id
End Sub

Can anyone help? Pleeese?

Make sure the textboxs referencing staffID really exist with those names on both forms.

It is also good practice to name Text Boxes "txtStaff_ID"

S-