By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,704 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

HELP - end of recordset

P: 1
I have a database that suddenly started saying...
You Can't go to the specified record
End of recordset

This is under the macro which asks it to open a form, maximize, go to a new record.

When I go to the plain form, which it is based from, it doesn't show any records.

Do I need to re-build completely.

Anna
Sep 4 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
I have a database that suddenly started saying...
You Can't go to the specified record
End of recordset

This is under the macro which asks it to open a form, maximize, go to a new record.

When I go to the plain form, which it is based from, it doesn't show any records.

Do I need to re-build completely.

Anna
No, here is all you need to do. The vba code below is very simple to implement.:

put the following on the onLoad event of your form

If Me.RecordSetClone.RecordCount = 0 Then
DoCmd.Close
End If


you can even put a msgbox before the docmd.close statement if you like
Sep 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.