Committing Information to a table from a form

[Joe B.]

Hi All,

I have created a form for users to input data into a table on a monthly basis. Within the form I wanted to restrict the user from seeing/editing previously input data so I set Data Entry = Yes, Allow Deletions = No, and Allow Edits = No.
However, I can see problem arising where the user realizes an input error right after it was entered and has no way to correct the error other than contacting the DBA. Is there a way to set up the form which allows the user to review/edit only the entries they have made during this particular month and not previous months, before committing the information to the database?
Once again, thanks for all your help.

Joe B.

 

[VilaRestal]

I think you'd need a second form with Allow Edits False and not Data Entry filtered to only show that person's entries during the last month.

And in the Data Entry from put code in the BeforeUpdate event asking them to check they've got everything right and to use this other form if need be.

To do it all in one form is going to be pretty fiddly for you to get the code right and not very user-friendly either I think.

 

[RainLover]

Add a Yes/No field to the Table.

Only show Non ticked records until they are commited at a convient time.

You could also add a Stamp to record who created the Record.
Search FOSUsername in Google.