CODEWITHSUNDEEP
ms-accessvbams-access-2010
Ivan Navratil
Ivan Navratil

Reputation: 13

How to give a warning message before going to empty record?

When I am navigating through records in my form I want to be informed when I click on next button that there are no more records (if there are no more records, ofc). By default in access, I am first shown a blank record and when I click again warning message.

Going through the record:

http://imgur.com/a/IaS4J

Going into an empty record:

Getting a warning message when clicking on next for the second time:

Upvotes: 0

Views: 78

Answers (1)

Gustav
Gustav

Reputation: 55841

It's easier to disable the button when the user reaches the new record:

Private Sub Form_Current

    Me!ButtonNext.Enabled = Not Me.NewRecord

End If

Upvotes: 1

Related Questions