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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

programmer - 09 Mar 2005 12:29 GMT

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.

Reply to this Message

Jeff Boyce - 09 Mar 2005 12:52 GMT

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?

Signature

More info, please ...

Jeff Boyce
<Access MVP>

> 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.

Reply to this Message

Rick Brandt - 09 Mar 2005 13:58 GMT

> 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.

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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

John Vinson - 09 Mar 2005 19:26 GMT

>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.

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]

Reply to this Message