I have created a form. I have account number as a combo box linked to a query "qryinputaccts" which chooses a subset (6200000 - 6999999) of the total accounts (6100000 - 6999999) from "Tblaccounts" i.e all non salary accounts.
I have the combo box control value for "Limit to List" set to "YES". As expected when I manually enter an invalid account number or a salary account number I get an error message.
In addition when I copy/paste an invalid account number "9999999" from my excel spreadsheet and paste it into the control it gives an error message.
However, when I copy/paste a valid salary account number 6110005 it accepts the value. I was expecting to get an error message.
Table tbldata is were the data is being stored. There are two types of records in the table. Accounts for budget, field "cat" with field value B1 and "cat" field value "A1" for actuals.
I am only adding A1 records in my form, and the form is set to default A1 in the "cat" field.
My only idea is that B1 records include salary accounts but A1 records do not. That is why I built the query to validate my form control against. I am guessing somehow this is allowing the copy/paste action to superseed the "Limit to List" editing.
Any idea what I am missing.
I have the combo box control value for "Limit to List" set to "YES". As expected when I manually enter an invalid account number or a salary account number I get an error message.
In addition when I copy/paste an invalid account number "9999999" from my excel spreadsheet and paste it into the control it gives an error message.
However, when I copy/paste a valid salary account number 6110005 it accepts the value. I was expecting to get an error message.
Table tbldata is were the data is being stored. There are two types of records in the table. Accounts for budget, field "cat" with field value B1 and "cat" field value "A1" for actuals.
I am only adding A1 records in my form, and the form is set to default A1 in the "cat" field.
My only idea is that B1 records include salary accounts but A1 records do not. That is why I built the query to validate my form control against. I am guessing somehow this is allowing the copy/paste action to superseed the "Limit to List" editing.
Any idea what I am missing.
Last edited: