Oh wise ones

I have a form that displays (or is supposed to) the record id in a textbox from the related table. This field "id" is an autonumber.

When viewed in Form view the id does not show up, however (AutoNumber) appears in its place complete with parenthesis.

I've tried all sorts of things to make the number show up but to no avail. Could any of you learned users shed some light on my problem.

Thanks

Richard
PS. Thanks to those who helped me the other day with the time stamping issue, worked like a charm.

go to Design View. look at the properties for the textbox, (Control Source). is it set to the id?
al

Al

Yep, the control is set to "id" but still no luck, any other thoughts?

Thanks

Richard

ok. then you are on a new record...
(adding a record)
access will not allow an entry into an autonumber field....

al

If you are saying that the recordsource for the form is a query that joins two tables and one of those tables has an autonumber field, you must not be adding anything to the table with the autonumber. Access automatically assigns the autonumber as soon as the record is "dirtied".

If the table is not a native Access table but is an ODBC table, Access does not assign the autonumber value. The remote database assigns it. Therefore, Access would not know the assigned value until after the record is added to the table.