B
Ben
Hi All,
I stumble on this error "The table 'Country' is already opened
exclusively by another user, or it is already open through the user interface
and cannot be manipulated programmatically."
What do I have going on :
I have a form ‘Doctors’ based on table ‘doctors’ with combo box ‘Country’
from table ‘country’.
Now, I created a query (doctorQuery) based on the same table which has a
parameter filter on ‘country’ (=[Combo] OR [Combo] is Null) and others via
form ‘search’. When I select a country in the unbound form ‘search’ to see
the doctors in that country in a continuous form based on the query, there is
no problem and I get a perfectly filtered list of doctors. I made the list
non editable (allowedits = false) and wanted a button per record to go from
the list of doctors to the form with all information on the doctor (all info
from table ‘doctors’). But when I click on the button, I get error message as
above.
I have the same with build up with other tables and those do not give any
problems… could it be the problem with relationship combo ?
Any help welcome !
Ben
I stumble on this error "The table 'Country' is already opened
exclusively by another user, or it is already open through the user interface
and cannot be manipulated programmatically."
What do I have going on :
I have a form ‘Doctors’ based on table ‘doctors’ with combo box ‘Country’
from table ‘country’.
Now, I created a query (doctorQuery) based on the same table which has a
parameter filter on ‘country’ (=[Combo] OR [Combo] is Null) and others via
form ‘search’. When I select a country in the unbound form ‘search’ to see
the doctors in that country in a continuous form based on the query, there is
no problem and I get a perfectly filtered list of doctors. I made the list
non editable (allowedits = false) and wanted a button per record to go from
the list of doctors to the form with all information on the doctor (all info
from table ‘doctors’). But when I click on the button, I get error message as
above.
I have the same with build up with other tables and those do not give any
problems… could it be the problem with relationship combo ?
Any help welcome !
Ben