How to Lock form to current niput only

[moles]

I have finished creating a form which is linked to a table where all the data enetered in the form is stored. Data is entered in this particular form once a day and is recorded uniquely in the table by date. The problem I have is that when a user opens the form to enter data they have the ability to scroll back and see previous days data using the scroll wheel on the mouse. Is there any way I can lock my form so users only have access to the current form in which they are entering data??

 

[mrf1xa]

If you only want to use your form for entering a single new record each day, and not for amending old records, thensetting the forms Data Entry property to Yes will ock it to the current record only and stop the scroll wheel performing this annoying little glitch!

hope this helps

Nigel

 

[WildHare]

Nigel is correct in his advice, but there may be other things to consider. If you set the DataEntry property to YES, then the form will open "blank", e.g. in preparation to ADD a new record. None of the existing records will be visible.

If you don't mind the person SEEING the other records, but would like to make them READONLY, you can set the AllowEdits and AllowDeletions to NO, the AllowAdditions to YES, and the DataEntry to NO.

This will show the other records, but make them un-editable and un-deletable. And also allow entry of a NEW record.

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[danvlas]

Form's Data Entry property: Yes

Sub Form_AfterInsert()
Requery
End Sub

Dan