Saving of incomplete records

[myztiques]

I have a table for OT(primary Key is ID that auto numbers) that the employee
goes in to a form and enter in the hours they are available to work for the
week and that does create a good record. The problem I am having is that if
the employee goes back in to make a change a new record is created with the
only the employee and week completed and the other fields blank.

The all the fields in the table are used in the form or subform. I have
tried to set up the form(main form) from the Table and a query. The subform
is created from a query. I can say that I am frustrated as this should be
simple in my mind and yet I am still working on this! urgh!!

So, basically, to clarify, we have a form that the employee opens and select
from the drop down the "week of" and "Employee Name". Then they go to the
subform and enter the amount of hours and then hit a command button to close
the form and save without prompt. This part works well...

Now the problem, if there is any chnages the employee goes into the same
form and when the week and employee is selected the previous information
comes up and whether they make any changes a new record is created with only
the name and week is completed and the remaining fields are blank regardless.

I am not sure if the problem is due to the subform but I do not know of a
better way for the form to show the information based on the week and
employee without requiring them to enter the information before the form
opens. The only reason why I did not want the employee to have to enter the
info before the form appears is that I want to avoid different dates or
misspelling whchc would create a new record.

At this point I am open to any suggestions and insight.

Help me please!!!!!!!

 

[Maurice]

It sounds like the form is set to data entry is that the case?

 

[myztiques]

That is correct. I thought you would want that in order to enter the data
the first time. So, where would I go from here?

 

[Maurice]

Data entry always sets up a new record despite the fact that you want to edit
it on a later time. In that case it's better to set the form to
dataentry=false when you want to edit something.

So you could think of an option to retrieve a certain record and open a copy
of the form not in dataentry mode and leave the original in tact.