Form with data entry only

Osix

Registered User.
Local time
Today, 14:24
Joined
Feb 3, 2011
Messages
19
I have form where proprty Data Entry = Yes. So, in theory only what can i do with this form is entry records (no record viewing from table, no edits, no delitions). But how about this?

Firstly, why Sort Ascending/Sort Descending is enabled?
Secondly, if I do Sort Ascending/Sort Descending then records displays on form.
Thirdly, when records are displayed I can edit records.

Is any way to disable Sort Ascending/Sort Descending on form?


 
Data entry only will include the records currently entered in the session. Which version of Access are you using so we can test out your supposition that clicking the sort brings back all of the records instead of just sorting on the ones that have been entered in that session.

If you don't want to allow ANY records to be available except the new one being worked on you can use this code in the form's After Update event:

Code:
Me.Requery
 

Users who are viewing this thread

Back
Top Bottom