Hi all,
A colleague of mine is creating a database (attached), but is getting run-time errors.
When it opens, a menu box opens for the user. Click on "Add Client" on this and it opens the 'AddClientInfo' form.
As you can guess, this is where the user will input client details.
There seems to be a problem with the "Sensor2" field, which is loose at the bottom of the form (because I have removed it and recreated it to try and fix this error previously). It is a multiple option combo box.
If that field is blank when I click the 'Add Client' button on this form, I get:
However, if I have chosen 1 or more options from that combo box I get:
When I debug, each error points to the same line:
.
Can anyone tell me what I have done wrong here, and how to fix it?
A colleague of mine is creating a database (attached), but is getting run-time errors.
When it opens, a menu box opens for the user. Click on "Add Client" on this and it opens the 'AddClientInfo' form.
As you can guess, this is where the user will input client details.
There seems to be a problem with the "Sensor2" field, which is loose at the bottom of the form (because I have removed it and recreated it to try and fix this error previously). It is a multiple option combo box.
If that field is blank when I click the 'Add Client' button on this form, I get:
Code:
Run-time error '64224': Method 'Value' of object 'Field2' failed.
However, if I have chosen 1 or more options from that combo box I get:
Code:
"Run-time error '3421': Data type conversion error"
When I debug, each error points to the same line:
Code:
rstAddClient("Sensor2").Value = CboSensor2.Value
Can anyone tell me what I have done wrong here, and how to fix it?