Combo box selection fills in list box

[Mouse51180]

What happens when you run that query without the where clause in sql design view. I presume you are getting some results?


Sent from my iPhone using Tapatalk

When I run the query, the output returns all Models and are sorted by Manufacturer. This is not the same order they appear in the table so I am guessing the query is working as expected.

[andy49]

Ok. Just to check what about adding

Msgbox me.cbomanufacturer


After the requery.
Just to confirm it's returning a value


Sent from my iPhone using Tapatalk

[Mouse51180]

Ok. Just to check what about adding

Msgbox me.cbomanufacturer


After the requery.
Just to confirm it's returning a value


Sent from my iPhone using Tapatalk

After adding the message box...when I select different manufacturers the message box pops up with the key id number of said manufacturer.

[andy49]

Aha. The combo is returningbthe wrong value
Change bound column?

Or change where clause to be fk_manufacturer?

Sent from my iPhone using Tapatalk

[Mouse51180]

Aha. The combo is returningbthe wrong value
Change bound column?

Or change where clause to be fk_manufacturer?

Sent from my iPhone using Tapatalk

GOOD NEWS
Changed the code in the row source from

SELECT [qryName].[ModelID], [qryName].[Model] FROM qryName WHERE [Manufacturer]=Forms!frmModel!cboManufacturer ORDER BY [Model];

to

SELECT [qryName].[ModelID], [qryName].[Model] FROM qryName WHERE [Manufacturer_FK]=Forms!frmModel!cboManufacturer ORDER BY [Model];

and it looks to be working now.

Got a new tool with the message box to diagnose issues like this in the future as well.

Thank you so much.

[andy49]

No probs. Good luck in your project


Sent from my iPhone using Tapatalk