auto numbering

[Guest]

a form in a database that i am working with would automatically insert a
number/id when entering "payment" information for a customer. this number
would remain the same for all payments for that particular record/person.
recently that number/id did not appear when a new record/person was created.
any time that a "payment" is entered for that record/person the database will
not save the information and i am assuming because of no number/id assigned.
all of the other records with id's save the payments. i have been working
with this for awhile, but still consider myself a novice. i have spent
several hours trying to locate the problem. does anyone have any suggestions?

 

[Steve Schapel]

Dbnelms

There are a number of ways in which the ID number would be inserted.

Are the payments entered via a subform? And is the field in question
entered in the Link Child Fields property of the subform? If so, it may
mean that the record in the Customer table for ther particular customer
concerned, does not have anything entered in the ID field, which is used
to relate the Customers table to the Payments table. This would be very
unusual, as it would mean that the ID (or whatever it's called) field in
the Customers table is not set as the primary key field, which it
normally would be under these circumstances. Are you abel to have a
look at the data in your Customers table, and see whether what I am
suggesting makes sense.

Another way that data is "automatically" entered on a form is via the
Default Value property. Can you have a look at the design view of the
Payments table, and see if there is anything entered in the Default
Value property of the CustomerID (or whatever it's called) field. Also,
in design view of the form, look at the properties of the textbox where
the ID number goes in, and see if there is anything entered in the
Default Value property.

It is also possible that the number is being generated by a macro or VBA
procedure, but let's check out the above first.