Ability to enter blank rows

[mpnorris]

Here is my situation:

I have a form which gives the users the ability to enter data. That is all I want them to be able to do. I have a "Add Record" button that will commit the data to the table.

The problem I have is that when you run the form, on the bottom of the form, you get the record counter "1 of X Records". You also have the forward and back arrows that let you scroll through the data. This gives the user the ability to bypass the checks I have put into the fields to prevent blanks from being entered into the database.

Is there a way to get rid of this functionality? I like the ability to scroll backward through the data that the user entered, but not the ability to scroll forward without using the "Add Record" button.

Any help or suggestions would be greatly appreciated.

 

[scriverb]

Yes, you can do this. There is a property of the form itself called Navigation Buttons. Change this property to NO. This will get rid of the navigation buttons.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[scriverb]

Another note. You should check out the Data Entry property of the form as this property controls whether the user can see the already existing records.

Also, check out with ACCESS Help the above along with the properties Allow Edits, Allow Additions, Allow Deletes. All of these properties work in concert with each other. I am sure you can find the right settings for your needs.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[mpnorris]

I was hoping it was that simple. Thenk you very much for your help. The things you find when testing. So many little intricacies.

Thanks again.

 

[scriverb]

Good luck with your project. Let me know if I can provide further assistance.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???