Form opens to records only for specific user?

[sara82]

I have a User Main Menu as seen below with the command buttons for New Work Log Entry and Edit Work Log Entry. The New Work Log entry opens a blank Work Log as shown below. The Work Log form's record source is tblWorkLog. The user will fill out all the fields except the End Page and Total Worked Pages. The user will then exit out of the database. When ready to enter the total worked pages the user log back in to the db and will click on the Edit Work Log Entry.

This is supposed to open up the last entry the current user was working on so that he or she can enter the End Page and Total Worked Pages

Currently it is opening up the last entry of the table even if it was a different user's.

How can I change this? I need it where it opens up the last record for that person. There are going to be 50 users so I can't have it open up to the last record of the table.

Any help will be apppreciated.

 

[JoeCruse]

First thing I can think of assumes that you use a query as the record source of the main form. If so, maybe you can set the underlying query to filter all records shown based on the username off the form (which, again assuming, is either from a app login or from using the environ trick to get the computer user's name). In doing this, you can have the app pull the user name on the form and conditionally open the recordest from the underlying query by sticking a criteria in the query. The form then opens to the last record, which is filtered to pull only the records done by the person logged in.

Something like that maybe???

 

[sara82]

JoeCruse:

The User Main Menu, does not have a record source it just hold the 4 command buttons. The WorkLog Form's record source is a table, tblWorkLog. Can I still do this even though the Worklog's form's record source is a table?