Simple Records Question

[icupat]

This is probably a very easy one to fix, but it's been a bit of a stumbling block for me.

I have a employees records for as part of my database (for the financial/payroll side use). I have one form with all the persons vitals (ie hire date/date of birth/name/etc), then you click on a button and this links to another form that simply has the persons PAY per hour and a field used to calculate their bonus pay.

However, I want to be able to have this second payscale form enter the pay into the correct persons name. But as of right now it simply goes to record ONE (1) as default. So I tried using the form_onload() and putting what below, but it didn't work.. any suggestions:

docmd.gotorecord , , forms![employeeform].currentrecord

'note: employeesform is the form with simple non-confidential details, so I was simply trying to have the popup for goto the same record (ie. same name, other info)...

Thanks for the help.

 

[Shirley]

Do you have an Employee ID for each Employee? If so try using this code on an event procedure. The particular one is set up to view a report, but it will lead you in th right diretion.

DoCmd.OpenReport "rptCertContract1", acPreview, , "[EmployeeID]=" & [EmployeeID]

I hope this helps