Display sequence of records in form

[Remco Steger]

My problem is the following:

I built a database for recording Non-Conformace Reports
(NCR). It basicaly is the soft copy of a paper version
used previously. I forced the AutoNumbering to start at a
certain number by putting in the number minus 1 via an
append query. Later on I put in existing NCR (auto)numbers
by append queries as well.

Now, when going through the records using the input form,
the records are shown by sequence of creation, instead of
sequence of the autonumber. How do I get Access to show my
records in the correct sequence - that is in sequence of
the Autonumber?

Does any one have a clue?

FYI: am running Windows2000 SP3 buil 2195 and Access2000
(9.0.2720)

 

[Gerald Stanley]

You should be able to achieve your desired result by
creating a query to select all the data from your table
sorted by the autoNumber column, then make this query the
RecordSource for your form.

Hope This Helps
Gerald Stanley MCSD

 

[Jim/Chris]

Base the form on a query based on the table and add your
custom sort criteria to the query.

Jim

 

[Remco]

Jim/Chris/Gerald,

The solution of using a query (that can be ordered by the
AutoNumber value) seems a logic one. However it raises the
following question:

New records still need to be put into the table. How can I
achieve this when the source for my form is a query?

Thanks!

 

[Gerald Stanley]

Behind the scenes, there is no difference to using a table
or a query as the RecordSource for a form. In either case,
Access creates a recordset with the information. The
decision as to whether new data can be added or existing
data edited or deleted depends on the form's properties
AllowAdditions, AllowEdits, AllowDeletions. The usual
problem that tends to occur with using queries is that some
people make them too difficult for Access to determine
where the info is to be stored. In this case, that is not
a problem.

Hope This Helps
Gerald Stanley MCSD