End of a Recordset

[ljwmis]

I have a database which uses a form to link information from a couple of tables and another external database. Sometimes an error message appears:

"You can't go to the specified record - You may be at the end of a recordset".

What does it mean? Are there any ways of diagnosing the problem?

Thanks.

 

[scriverb]

Your forms RecordSource is either a table or a query with linked tables. The records that are made available to the form by either of these is called the recordset. If you have code on your form that tells ACCESS to go to a record beyond the last record in the recordset you will receive this error. Usually the navigation buttons on a form keep you from doing this. If you try to go past the last record a NEW record blank form appears ready for you to create a new record.

Where in your code or what action were you taking when this error appeared?

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[ljwmis]

The problem involves a staff training db which is linked to a staff details db.

The RecordSource you mention refers to a table called "establishment" within the linked staff details db.


Operation:

The user opens the staff training main form and uses 'find' (the binoculars icon) to find the member of staffs name. The relevant fields are completed by the selction of the staff name from the 'establishment' find results and the user then enters the relevant training course details. When she selects 'new record' the error message "You can't go to the specified record - You may be at the end of a recordset" appears.

Hope this clarifies the problem.