SubField Error - Access Developer Network


	Back to Access Developer Network Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

SubField Error

Abraham Breuer

5 years ago

anyone to help me?
I am having trouble when adding data to my subform, when I add a line to the subform I get this error (see below the screenshot) and the child's field (The field which should be making the relation between the master and subform) doesn't get edited

	Abraham Breuer OP @Reply 5 years ago

	Richard Rost @Reply 5 years ago
Did you run down the Troubleshooter?

	Abraham Breuer OP @Reply 5 years ago
tried a lot of different ways but doesn't fix the problem I have no ole objects maby something to do with ActiveX but I have no clue what ActiveX is Do you cover this topic anywhere?

	Richard Rost @Reply 5 years ago
Only to tell you NOT to use them. In fact I just searched my outline, and the 2nd line under Access Developer 18, Lesson 1 says "Problems with ActiveX Controls." Try moving the form to a brand new, empty database WITHOUT any other ActiveX controls in it, and see if it works there.

	Richard Rost @Reply 5 years ago
Could also be caused by having a table or form with an OLE Field. Again, I hate those. Get rid of them.

Abraham Breuer OP @Reply

5 years ago

Found that when I use the form wizard I don't get this error message, and the subform is working fine.
It's for sure the ActiveX control, however, I don't have any idea what ActiveX is, I guess I will need to have Patience until I get to Developer 18!!!
I believe that these obstacles give me the way to understand better how things work, experience doesn't just mean more years but proper understanding!!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Network.

Next Unseen

New Feature: Comment Live View