Run Time Error: Update or CancelUpdate

T

Ted James

Eheh umm I deviated from my "proper" naming structure and
named a label "AccountType" which is the name of a record
in the record set. So the line

Forms!frmDataInput!subAccount.Form!AccountType = DLookup
("[AccountType]", "tblAccountTypes", "[AccountID]= '" &
Right(Forms!frmDataInput!subAccount.Form!AccountNumber,
1) & "'")

Caused problems.

Forms!frmDataInput!subAccount.Form!lblAccountType.Caption
= DLookup("[AccountType]", "tblAccountTypes", "[AccountID]
= '" & Right(Forms!frmDataInput!subAccount.Form!
AccountNumber, 1) & "'")

Works since it no longer confuses the program with the
control and the recordset having the AccountType
similarity.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update or CancelUpdate without AddNew 1
Prevent foreign key autofill in linked subform 0
Run-time error 2001 on DLookup 4
Help on error message 0
Update or CancelUpdate without AddNew or Edit. (Error 3020) 0
Run Time Error 3027 - Can't update. Database or object is read only 1
Run time error 438 1
Update or CancelUpdate without AddNew or Edit 5

Top