And once again following problem has occured.
I use form (print) for filtering prints. The form contains following fields: Customer(Combobox) and some other fields.
The problem is that combobox beacause it throws following error: The Database engine could not lock table 'customers' because it is already use by another person or process.
I'am sure that there are not open any table.
Weird thing is that i tested how the textfield and combobox works when filtering prints.
When i have textfield customer1 and combobox customer2 then in the query i have use that when i write something in the field and press button then it opens report and it works fine, but when i use customer2 then it not work and i have try using code in the combobox but it not work.
Code in combobox.
Docmd.gotocontrol "customer2"
Docmd.runcommand accopy or something like that
Docmd.gotocontrol "customer1"
Docmd.runcommand acpaste or something like that
Now that work ok but now in the query is using that customer1 field that works fine when i write that customer, now it should work but it isn´t.
Please help this is very frustrating.
I use form (print) for filtering prints. The form contains following fields: Customer(Combobox) and some other fields.
The problem is that combobox beacause it throws following error: The Database engine could not lock table 'customers' because it is already use by another person or process.
I'am sure that there are not open any table.
Weird thing is that i tested how the textfield and combobox works when filtering prints.
When i have textfield customer1 and combobox customer2 then in the query i have use that when i write something in the field and press button then it opens report and it works fine, but when i use customer2 then it not work and i have try using code in the combobox but it not work.
Code in combobox.
Docmd.gotocontrol "customer2"
Docmd.runcommand accopy or something like that
Docmd.gotocontrol "customer1"
Docmd.runcommand acpaste or something like that
Now that work ok but now in the query is using that customer1 field that works fine when i write that customer, now it should work but it isn´t.
Please help this is very frustrating.