Originally Posted by
andy49
Hi mouse.
I think the issue here is that your list box says "please list all models and modelid where the manufacturer is e.g. DELL.
BUT, none of your models is
Called "DELL" so it's returning nothing.
This is one possible solution I think. The others may have better.
Create a query in design view of your two tables showing all the fields. (I'll Call it qryname)
Then make your list box rowsource
Select qryname.modelid, qryname.model from qryname where manufacturer = forms!frmmodel!cbomanufacturer order by model;
Fingers crossed!!
Sent from my iPhone using Tapatalk
Im afraid that did not seem to work.
I have attached a screenshot of the query and settings.
I tried
Code:
Select qryname.modelid, qryname.model from qryname where manufacturer = forms!frmmodel!cbomanufacturer order by model;
as well as
Code:
SELECT [qryName].[ModelID], [qryName].[Model] FROM qryName WHERE [Manufacturer]=Forms!frmModel!cboManufacturer ORDER BY [Model];
to make sure it wasnt a syntax issue.
Both code allowed me to choose the manufacturer from the drop down menu, but produced no results in the list box.