Default Value - Last Entry

[jnb22019]

Some details first:

Access 2010

Main Form - Name of Company
Sub form - Name of Employee
Sub "sub" form - Date, hours worked, Purchase Order (PO)

You may have guessed that I first select the company, I then select an employee from that agency and then write in the amount of hours, etc.



What I want to do is that whenever I write I date on the sub "sub" form, both the hours and Purchase Order are automatically filled by the last entry for that same employee.

Example -

Company X
- John Doe
- 4/1/12 - 8 hours, PO # 1-11111111
- 4/2/12 - automatically populated by last entry (above) and can be changed if necessary.

Any ideas?

[RuralGuy]

Similar code to: http://access.mvps.org/access/forms/frm0012.htm in the BeforeUpdate event of the SubSubForm should do it.

[jnb22019]

Similar code to: http://access.mvps.org/access/forms/frm0012.htm in the BeforeUpdate event of the SubSubForm should do it.

The code is not working for me. I get nothing if I do the BeforeUpdate, BeforeInsert and not even a button with a click event.

[RuralGuy]

Copy and Paste the code you are trying into a post here so we can see it.