inserting new records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way to insert a new record into the middle of a form? I want a
record to come before another record but when i insert the new record is
always is inserted as the last record, is there a way i can change this?
 
That is correct, you will insert it at the end. Your sorting for the form
controls in which order a list of records displays. This sorting can be
used in your queries, reports, and forms. The actual order of the records
in the table does not really matter.

If you want records to display in the order in which they were added to the
database (and you want to be able to go back and insert records in between)
then you will need to include a transaction date/time or some similar field
in your records so they can be sorted appropriately.
 
You need to realize that there is no inherent order to records in a database
or in the way they will be returned by an unordered query. That being said,
there really is no such thing as "the middle of a form." You need to find
some basis for sorting your records to get them in the order you want.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Back
Top