form/subform error

  • Thread starter smcgrath via AccessMonster.com
  • Start date
S

smcgrath via AccessMonster.com

my form and subform were working perfectly fine yesterday but today I am
getting the following error when trying to enter new data:

Microsoft jet database engine cannot find a record in tblpayoff with key
matching field(s) 'Account Number'

AccountNumber is the primary key in the tblpayoff and the Fk in the
tbldischarge. What is causing the error.
 
J

Jeff L

It is possible that you are referring to Account Number, when it should
be AccountNumber. I noticed you put it both ways.

It could also be that an account number has been deleted or changed in
tblPayoff and now tblDischarge is trying to match that value (because
it's the foreign key) and cannot.

Hope that helps!
 
S

smcgrath via AccessMonster.com

Thanks - I changed the account number name and did not change the group/sort
option in the form.

Jeff said:
It is possible that you are referring to Account Number, when it should
be AccountNumber. I noticed you put it both ways.

It could also be that an account number has been deleted or changed in
tblPayoff and now tblDischarge is trying to match that value (because
it's the foreign key) and cannot.

Hope that helps!
my form and subform were working perfectly fine yesterday but today I am
getting the following error when trying to enter new data:
Click to expand...
[quoted text clipped - 4 lines]
AccountNumber is the primary key in the tblpayoff and the Fk in the
tbldischarge. What is causing the error.
Click to expand...
Click to expand...
 
Top