R
rajna
I would like to report a bug in MS Access 2000 that
occurred in a VBA module after conversion from MS Access
97.
The Control Source property is not set to anything and I
am not trying to add/change any data to any of fields in
my table. The second combo box get the correct data from
my table according to the selection in 1st combo box, the
error occurs when I try to select some of those values
from the second combo box dropdown list. I am just trying
to make a selection from the dropdown list of the second
combo box and it doesn't let me to do it. I want to just
populate the text portion of the combo box control with
the value from the dropdown list, that's all.
I set the Row Source Type property of the first combo box
to Field List. That means the 1st combo box displays a
list of the fields available from the Record Source, which
is in my case 'FOC905_Current' table. The 1st combo box
will display the names of all fields in that table.
The Row Source Type property of the second combo box I set
to Table/Query, which means that SQL statement, query or a
table will supply the data in the second combo box. In my
case the SQL statement depends on the selection in 1st
combo box.
If I select 'JOBNUM' from the 1st combo box, the second
combo box will display data from that field
in 'FOC905_Current' table and so on.
'JOBNUM' field in 'FOC905_Current' table is a numeric data
type field.
Second field in my table is 'PROCODE' which is not
numeric.
The problem with the combo box control is that when I
select 'PROCODE' in the 1st combo box, after I selected
and executed the dynamically created query based on the
numeric field name like 'JOBNUM', I get the error on the
second combo box -
Microsoft Access
The value you entered isn’t valid for this field.
For example, you may have entered text in a numeric field
or a number that is larger than the Field Size setting
permits.
This error is not NORMAL for the combo box control. The
combo box shouldn’t behave this way.
Thank you in advance for your help!
Rajna
occurred in a VBA module after conversion from MS Access
97.
The Control Source property is not set to anything and I
am not trying to add/change any data to any of fields in
my table. The second combo box get the correct data from
my table according to the selection in 1st combo box, the
error occurs when I try to select some of those values
from the second combo box dropdown list. I am just trying
to make a selection from the dropdown list of the second
combo box and it doesn't let me to do it. I want to just
populate the text portion of the combo box control with
the value from the dropdown list, that's all.
I set the Row Source Type property of the first combo box
to Field List. That means the 1st combo box displays a
list of the fields available from the Record Source, which
is in my case 'FOC905_Current' table. The 1st combo box
will display the names of all fields in that table.
The Row Source Type property of the second combo box I set
to Table/Query, which means that SQL statement, query or a
table will supply the data in the second combo box. In my
case the SQL statement depends on the selection in 1st
combo box.
If I select 'JOBNUM' from the 1st combo box, the second
combo box will display data from that field
in 'FOC905_Current' table and so on.
'JOBNUM' field in 'FOC905_Current' table is a numeric data
type field.
Second field in my table is 'PROCODE' which is not
numeric.
The problem with the combo box control is that when I
select 'PROCODE' in the 1st combo box, after I selected
and executed the dynamically created query based on the
numeric field name like 'JOBNUM', I get the error on the
second combo box -
Microsoft Access
The value you entered isn’t valid for this field.
For example, you may have entered text in a numeric field
or a number that is larger than the Field Size setting
permits.
This error is not NORMAL for the combo box control. The
combo box shouldn’t behave this way.
Thank you in advance for your help!
Rajna