Adding record

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

Guest

I use a form to add new entry in my database. In my form i have a command
button called "add record" when i press this button i get a blank form where
I make new entry. My problem is when I check the data later in acess table,
new adentries do not appear in the end of the row (I would like to have new
entry to be in the end of sequential number) instead they get entered in
different rows before the old entry. Any suggestio/help will be highly
appreciated.

Thanks
 
A table is just a bucket to hold records. In theory, it has no order at all,
and you have to specify an order if you want one. You do that by using a
query that sorts the records as desired. If you want to sort them in the
order they were entered, you need to use an AutoNumber, or a Date/Time field
that records when they were entered.

In practice, Access displays the table in the order of the primary key by
default. Simply adding an AutoNumber to the table will probably give you
what you want.
 
Back
Top