my table is indexed, but after entering records by form, it's not.

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

Guest

I have created a form having one indexed primary field. when I add any data
to form and save it, by click on record mover [what I have created] , all
data are not indexed.
 
It may be that your definition of "indexed" doesn't match Access'
definition.

Forms don't have fields, and don't have indexes. Tables do. Can you
provide a bit more explanation?
 
programmer said:
I have created a form having one indexed primary field. when I add
any data to form and save it, by click on record mover [what I have
created] , all data are not indexed.
Click to expand...

If you mean that they are not in any particular order then you should know
that tables by definition have no order. Anytime you want records in a
particular order you must impose that order within a query, form, or report.
 
I have created a form having one indexed primary field. when I add any data
to form and save it, by click on record mover [what I have created] , all
data are not indexed.
Click to expand...

Unlike the case with some other database programs, specifying an index
does NOT sort the table.

It does make sorting the data in a Query faster and more efficient, so
it's a good thing to do - but if you want to see the data sorted, use
a Query, not a table datasheet.

John W. Vinson[MVP]
 
Back
Top