Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering report using combobox.

Status
Not open for further replies.

Jar80

Technical User
Jun 13, 2004
69
FI
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.


 
Hi, it is not clear to me what you wish to do.

Do you wish to print a report based on a filtered form?

Do you wish to print a report based on selected criteria in a form?

 
I wish to print a report based on selected criteria in a form?
 
Hi, how about posting the sql from your report. I think that would make it a little clearer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top