Synchronized Combo Boxes in Forms

[Ghaznavi]

Hi...
I have searched on internet for the method of synchronizing two combo boxes in a form based on Update Event. The problem was solved partially with the help of this video : (link is not posted due to lesser number of posts. But it can be found on net, it's title is "Synchronizing Combo Boxes on Forms in Access 2007 " from Office Developer Centre.


But one thing is not yet resoved. When I followed the instructions in the video, it works but showed only the ID numbers of the categories in the first combobox. and the corresponding products in the second combo. Why cant I see the names of the categories?
In the video, the names are visible in combo, i follwed the same code but instead of names, IDs are shown.

What is the solution?

 

[JHB]

Have you set the column count to 2?

 

[Ghaznavi]

Have you set the column count to 2?

Great tip...Problem is solved...Thanks & Hats off for you

 

[JHB]

Good it solved your problem - good luck.

 

[Ghaznavi]

Hi...
The problem was solved and after that I added two more combo boxes following the same procedure in the same form, but this time it is not working and displaying following message:
runtime arror '-2147352567(80020009):
The value you entered is not valid for this field

The first two comboboxes are still working correctly. I have checked and followed the same procedure for the new ones but why it does not work ??
Kindly help.

 

[JHB]

Post a stripped version of your database with some sample data, (zip it) + information in which form and which combo box you have the problem!

 

[Ghaznavi]

Post a stripped version of your database with some sample data, (zip it) + information in which form and which combo box you have the problem!

Zip file is attached here..

 

[Ghaznavi]

Zip file is attached here..

In the form Transactins, two comboboxes Categories and ItemNames are working fine. But other two (WorkOrders and Products) are not working same way.

 

[JHB]

    Me.cboProducts.RowSource = "SELECT Product FROM" & _
                               " tbProducts WHERE WorkOrders = " & _
                               Me.cboWorkOrders & _
                               " ORDER BY PartMark"

There is no field with the name "Product" in the table "tbProducts".

 

[Ghaznavi]

Thank you very much for mentioning the mistake