My Access database is mixing up the record numbers in the table

[Guest]

My Database is mixing up the record in the table and the form. It says its a
1017 system error. How do I get the records back into their correct order?

 

[Douglas J Steele]

What exactly are the symptoms?

You do realize, I hope, that you cannot make any assumptions about the order
of records in tables.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

My Database is mixing up the record in the table and the form. It says its a
1017 system error. How do I get the records back into their correct

order?

 

[Guest]

Records are not stored in any order. You can display them in an order by
indexing or setting sort in a query, form or report.

 

[Joseph Meehan]

My Database is mixing up the record in the table and the form. It
says its a 1017 system error. How do I get the records back into
their correct order?

What record numbers? Access does not have record numbers.

Records in a table are not in a specific order. If you want records in
an order, you need to provide for that. Considering a table as a bucket of
data is the best way of handling it.

Autonumber is not intended as a way of providing a record order, only a
way of providing a unique number for each record.

How does the error message fit into the problem?

 

['69 Camaro]

Hi.

It says its a
1017 system error.

Do you mean system error -1017? If so, what's the exact error message? The
error number means different things, depending upon the context, such as a
replicated database's synch error, a compaction error, or a conversion
error.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.