By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,101 Members | 1,463 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,101 IT Pros & Developers. It's quick & easy.

adding Record autonumber problem

P: n/a
hello,

i have a form with a table on its back. The primary key is an autonumber
field called "ID". I have a textfield displaying the value of this field
(just for my info, data is sure entered in other fields). When i add a
record with the "new record" button, there is no id created, and i cant
save the new entries. What am i doing wrong?
regards, Oli
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Oliver Gabriel wrote:
hello,

i have a form with a table on its back. The primary key is an autonumber
field called "ID". I have a textfield displaying the value of this field
(just for my info, data is sure entered in other fields). When i add a
record with the "new record" button, there is no id created, and i cant
save the new entries. What am i doing wrong?
regards, Oli


Problem no longer persists.
Nov 13 '05 #2

P: n/a
The record source for your form is either a table or a query.
Can you enter records directly into the record source? If not, try changing
the query so that it is updateable.

If you can enter records directly into the table or query, then the problem
must be with your form. Open it in design view and check that Allow Edits
and Allow Additions are set to "Yes".

Then check that the controls (form fields) that you are trying to enter data
in have the Enabled property set to "Yes" and Locked set to "No".

Post back if none of this helps.
-Ed
"Oliver Gabriel" <ti****@allgaeu.org> wrote in message
news:dh**********@svr7.m-online.net...
hello,

i have a form with a table on its back. The primary key is an autonumber
field called "ID". I have a textfield displaying the value of this field
(just for my info, data is sure entered in other fields). When i add a
record with the "new record" button, there is no id created, and i cant
save the new entries. What am i doing wrong?
regards, Oli

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.