Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error updating form

Status
Not open for further replies.
jcpelejo

jcpelejo

Programmer
Jul 29, 2001
70
US
Hello. I have a form called "Manual Claims System - MR Canada." I access the form via a "Login Form". The "Login Form" brings me to a new record on the "Manual Claims System - MR Canada" form but does not auto generate the AutoNumber in the [txtClaimNumber1] field. When I go to the Manual Claims System - MR Canada" form directly and select a User ID from the [UserID] combo box, it generates the AutoNumber in the [txtClaimNumber1] field but when I try and go into another field, it displays with the message "The Microsoft Jet engine cannot find a record in the table Client with key matching field(s) 'ClientNumber'." Please advise. Life is too short to waste...
Julius Pelejo
jcpelejo@hotmail.com
 
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Error 2004
Replies
2
Views
438
lameid
lameid
renigar
  • Locked
  • Question
Access VBA Syntax Error 1
Replies
5
Views
4K
Andrzejek
Andrzejek
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
748
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
833
dhookom
dhookom
ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
996
mattKnight
mattKnight

Part and Inventory Search

Sponsor

Back
Top