Lets say... the custumer no. is the primary key in the main form. When this
key is entered it is automatically updated on the subform.
Scenario: nextday I discovered that the customer no. was entered incorrectly.
I try to correct the customer no., but what happens is because I am putting
in a different customer no. the result is I have entered a new record
instead of correcting the incorrectly entered record.
I have one-to-many relationship with all 3 boxes checked , enforced
Referential Intergity , Cascade update related fields and cascade delete
related records.
This is a little data entry form that I have developed for a client.
I am also having problems with date entries... when the set format is
mmddyyyy and the data that has been entered is 31032006... Access seems to
switch the ddmm to mmdd for me automatically...I would like it to tell the
entry person to stop and look.
How do I do that? Is there something I have to turn off?