J
Jay
I've been learning how to insert cascading combo boxes recently (newbie),
and in my practice mdb I keep getting an error message.
I have a simple form with a 'Company' combo box & a 'Location' List box. The
locations displayed depend on the company chosen in the combo box. The
source table is tblCompanyLocation. However I keep getting the following
error:
'The table 'tblCompanyLocation' is already opened exclusively by another
user, or it is already open through the user interface and cannot be
manipulated programmatically'
However, the error is intermittent? If I close the mdb & re-open it
dissapears? Anyone any advice?
Also, how can I get the list displayed in the list box (after the combo is
updated) to clear when I progress to the next new record? At the moment the
previous record's values show. They change OK when the combo is updated but
I want all fields on the form clear when the next new record is navigated
to.
Many TIA,
Cheers
Jay
and in my practice mdb I keep getting an error message.
I have a simple form with a 'Company' combo box & a 'Location' List box. The
locations displayed depend on the company chosen in the combo box. The
source table is tblCompanyLocation. However I keep getting the following
error:
'The table 'tblCompanyLocation' is already opened exclusively by another
user, or it is already open through the user interface and cannot be
manipulated programmatically'
However, the error is intermittent? If I close the mdb & re-open it
dissapears? Anyone any advice?
Also, how can I get the list displayed in the list box (after the combo is
updated) to clear when I progress to the next new record? At the moment the
previous record's values show. They change OK when the combo is updated but
I want all fields on the form clear when the next new record is navigated
to.
Many TIA,
Cheers
Jay