S
shers
I have a main form that is used to enter data into a main
table. In this form, one of the controls is a Combo box
that is linked to another table from where it displays a
list in two columns when dropped down. The combo box is
bound to the first column and the corresponding second
column data is displayed in a text box by setting the
Control Source property of the text box to =[combo1].
[column](1). If the user types a data in the Combo box
that is not there in the list, I would like to have a
message box that tells the user to click a particular
command button to add the new data. When the command
button is clicked, a subform shows up.
Now my problem is that when the command button is clicked,
once the combo box is clicked, it gives me an error as
follows:
" The table 'Table Name' is already opened exclusivly by
another user, or it is already opened through the user
interface and cannot be manipulated programmatically. "
Why is this happening? Can anybody please help me.
table. In this form, one of the controls is a Combo box
that is linked to another table from where it displays a
list in two columns when dropped down. The combo box is
bound to the first column and the corresponding second
column data is displayed in a text box by setting the
Control Source property of the text box to =[combo1].
[column](1). If the user types a data in the Combo box
that is not there in the list, I would like to have a
message box that tells the user to click a particular
command button to add the new data. When the command
button is clicked, a subform shows up.
Now my problem is that when the command button is clicked,
once the combo box is clicked, it gives me an error as
follows:
" The table 'Table Name' is already opened exclusivly by
another user, or it is already opened through the user
interface and cannot be manipulated programmatically. "
Why is this happening? Can anybody please help me.