Save as Draft

[MySki]

I have a main form with about 20 fields on it. The main form is used to collect information on employees. I have several fields on the main form that I need to make mandatory, such as SSN, DOB, Org. Code, etc. Herein lies my problem:

If I make the fields required, the user will not be able to exit the form without entering the information into the specified field. However, when the user is doing the data entry, they don't always have all of the required inforamtion to fill in these fields.

Is there anyway to save the information that is partially inputted as a "draft" until the user can come back and fill in the required fields...... without getting the required field error when they try to exit.

I hope I'm making sense.

Thanks!!!

 

[missinglinq]

This basically comes under the category of "You can't have it both ways". Either the fields are mandatory, or they're not. If you insist on having all data present before adding a record to the table, the only work around I can think of would be to have two tables.

Table #1: None of the fields are mandatory. The user could enter whatever data they have, then exit. Later they could return to fill in the missing data. The data entry form for this table would have a command button that is to be clicked on when all the necessary data is present. The On Click property for this button would fire an Append Query which would add the record to Table #2. If the button is clicked without all the needed data being present, a Message Box would appear explaining the user's transgressions to him/her. A separate (though basically identical) form would be needed to view the second table.

Hope this helps.

The Missinglinq "It's got to be the going,
not the getting there that's good!"
-Harry Chapin