Problems Updating fields: Please help!
I have a problem and its giving me a serious headache! Maybe you guys could help me?
I've got a blank form which you can fill out progressively. Firstly, when you add a new record, a popup appears asking you to fill in a company name and subsidiary. When you've done that, you should click "continue" and the database should pull in all the associated fields to do with the selected company into the form for you.
Unfortunately, once you have selected the company (picture 1), it deletes the new record and gives an error message (picture 2: "Runtime error 2101: The setting you entered isn't valid for this property").
Picture 3 shows the error message and underlying coding.
Picture 4 shows modCommon which is referred to in the error line.
Any help you could give would be much appreciated as I am completely stumped!
I have a problem and its giving me a serious headache! Maybe you guys could help me?
I've got a blank form which you can fill out progressively. Firstly, when you add a new record, a popup appears asking you to fill in a company name and subsidiary. When you've done that, you should click "continue" and the database should pull in all the associated fields to do with the selected company into the form for you.
Unfortunately, once you have selected the company (picture 1), it deletes the new record and gives an error message (picture 2: "Runtime error 2101: The setting you entered isn't valid for this property").
Picture 3 shows the error message and underlying coding.
Picture 4 shows modCommon which is referred to in the error line.
Any help you could give would be much appreciated as I am completely stumped!
Attachments
Last edited: