Autonumber requesting numbers, how to reset all this please?

  • Thread starter Thread starter Austen
  • Start date Start date
A

Austen

I have an autonumber set on my form, or thought I had. It is requesting info
in terms of no 'Autono' appearing. How do I sort this out as it is also the
primary key. Can I do this without breaking relationships and etc. Please
help.
 
I have an autonumber set on my form,
Autonumbers are in tables and normally are not for human consumption or
viewing.
Is it a field in your table?
What is the field named?
Is there an object on your form that is bound to the autonumber field in the
table?
Why are you displaying it on your form?
What is the exact prompt that it is displaying?
 
I have an autonumber set on my form, or thought I had. It is requesting info
in terms of no 'Autono' appearing. How do I sort this out as it is also the
primary key. Can I do this without breaking relationships and etc. Please
help.
Click to expand...

Forms don't have autonumbers. Tables do. Generally autonumbers need not and
should not be displayed on forms at all; they're best kept "under the hood"
for relating tables.

What is the structure of your Table? What is the Recordsource of the form?
What does "Autono" mean - that's not something I've ever seen in Access. What
do you mean by "requesting numbers"?
 
Sorry it apears I was too loose with my terms.

I have an autonumber in my table. The field is named ID1. On a table called
TBL_Delta. This was set as an autonumber when setting up the form. On
creating the form the ID1 was displayed in it. This is usually automatically
there upon pressing 'add button' command on the form. For some reason now it
displays a blank cell rather than a number.
Can you help?
 
Sorry it apears I was too loose with my terms.

I have an autonumber in my table. The field is named ID1. On a table called
TBL_Delta. This was set as an autonumber when setting up the form. On
creating the form the ID1 was displayed in it. This is usually automatically
there upon pressing 'add button' command on the form. For some reason now it
displays a blank cell rather than a number.
Can you help?
Click to expand...

Well, something might be corrupt or damaged. MAKE A BACKUP now (but keep any
older backup, you may need it); try Tools... Database Utilities... Compact and
Repair to see if that helps.

If not, open the table as a datasheet. Do all records have a value in ID1?

Then open the Form in design view. What is its Recordsource property? What
about its Data Entry property? What is the Control Source property of the
textbox on the form where you're expecting to see the ID1 value?
 
Back
Top