combo box doesn't work on tag/subform

miltiadis21

Junior Programmer
Local time
Today, 14:18
Joined
Jul 11, 2007
Messages
44
combo box doesn't work on tab control

Hello i have a problem
I have synchronize two combo boxes on a form named "Combo" and they are working fine
The problem arises when i am putting them on a tag in a new form"industry".There i am getting this msg (See the "access.png" attachment)
and i cannot make them work on this new form!.

The first combo box(SubSector) i have named it cboSubSector and the Second combo box (Process) i have named it cboProcess

As you can see i have create a parametrized query in the cboProcess (See the "querycbo.PNG" attachment ) in order to be synchronized and to display related data.
This query is working fine on the "combo" form but not in the "industry" form where the tag exists

My Problem is that i don't know how to reference it on the new form"Industry" and i am getting an error as i have described in the "access.png"
Also i have experiment a lot without any solution...!

Thanks for your ideas/Solutions
 

Attachments

  • access.PNG
    access.PNG
    13.1 KB · Views: 124
  • querycbo.PNG
    querycbo.PNG
    15.5 KB · Views: 128
Last edited:
Ok i have solved this
If anyone has stuck with something similar in the future it may help.
Solution i changed the [Forms]![Bound Form]![combobox]
with this parametrized query in the subform with this [Forms]![MainForm]![Subform]![combobox] and it work

Tip when you stuck with something a good sleep will help you see the thinks much better;)
 

Users who are viewing this thread

Back
Top Bottom