Add a Record at the Top - New Record on Top in Microsoft Access


	Back to New Record on Top Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Add a Record at the Top

Stephen Fugowski

2 years ago

I watched the video on adding a record at the top of a form. When I tried it out, I got an error about a validation rule. A field on the table has a validation rule "Is Not Null". The error appears when trying to do the "Me.Requery" command. Is there a way to temporarily avoiding the validation rule?

	Stephen Fugowski OP @Reply 2 years ago

	Alex Hedley @Reply 2 years ago
Did you populate `DSVol` with a value?

	Stephen Fugowski OP @Reply 2 years ago
Not on the new record. The user has to do that.

	Alex Hedley @Reply 2 years ago
So is your process to populate some of the fields first then pass it on to a colleague to complete the rest? Before you swapped to Record on top wouldn't the same issue have occurred?

	Stephen Fugowski OP @Reply 2 years ago

	Stephen Fugowski OP @Reply 2 years ago
It doesn't happen when the new record is on the bottom, only when I try to add a new record on the top. The error appears before the Me.Requery command is executed.

	Alex Hedley @Reply 2 years ago
But did you click that button before or is that new to this?

	Stephen Fugowski OP @Reply 2 years ago
I added the button after watching the video. I used the code that was in the video.

	Kevin Robertson @Reply 2 years ago
Using this technique you will need to remove the Validation Rule. If you need to validate data entry use the technique Richard shows in the Extended Cut.

	Stephen Fugowski OP @Reply 2 years ago
I cannot find the extended cut. Do you know the link to the extended cut?

	Kevin Robertson @Reply 2 years ago
New Record on Top Look under the Members section.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in New Record on Top.

Next Unseen

New Feature: Comment Live View