Well we could be getting to the problem, in the recordsource it says
TblComplaints, which would be the table for our complaints, then when I click
Query Design window thing it says "You invoked the query builder on a table.
Do you want to create a query based on the table?" Does this help? Thanks so
much!

John W. Vinson wrote:
Hi Jeff, Thanks for responding.
We enter that number based on the entry before it, it is not something that
[quoted text clipped - 5 lines]
not know much about setting these things up and the person that did is long
gone. Thanks again.

Access data is not stored in Forms - the form is just a window, and the data
is stored in a Table. The Form has a "recordsource" property which might be
the name of a table or of a query.

Data in tables *has no order* - it's just a heap of records. If you want a
specific order you must use a Query sorting the records; it's possible that
the person who set this database up did so incorrectly.

Open the Form in design view, and look at its Properties. Find the
Recordsource property (first on the data tab) - what's in it? Click the ...
icon by the property to open a Query Design window; if Access lets you do so,
select View... SQL on the menu and copy and paste the SQL text to a message
here (it may look like Sanskrit to you at this point but there are gurus
here...)