gakiss2
Registered User.
- Local time
- Today, 04:58
- Joined
- Nov 21, 2018
- Messages
- 168
I have a combo box which I want to provide categories based on the name of the vendor. If I literally put the name of one of my vendors in the Row Source query it works. When I put the name of the control the vendor name should come form I just get no nothing in the combo box (nothing passes the filter) Here is the Query with the literal vendor name:
this 'works' but obviously it doesn't. It gives me the categories it should when HYCO Canada is the Vendor but this needs to work for all vendors as I move from record to record. Here is the query I tried which didn't work.
I have used Msgbox to verify that Forms!frmMRRLog!SupplierName give the right Vendor.
I have vba code on another Cbo box but I don't think it would affect this.
It seems like the query I tried should work but for some reason its not. Help is appreciated.
Thanks in Advance
Code:
SELECT tblCategory.ID, tblCategory.VendorName, tblCategory.Category FROM tblCategory WHERE (((tblCategory.VendorName)="HYCO CANADA, LTD"));
this 'works' but obviously it doesn't. It gives me the categories it should when HYCO Canada is the Vendor but this needs to work for all vendors as I move from record to record. Here is the query I tried which didn't work.
Code:
SELECT tblCategory.ID, tblCategory.VendorName, tblCategory.Category FROM tblCategory WHERE (((tblCategory.VendorName)=Forms!frmMRRLog!SupplierName));
I have used Msgbox to verify that Forms!frmMRRLog!SupplierName give the right Vendor.
I have vba code on another Cbo box but I don't think it would affect this.
It seems like the query I tried should work but for some reason its not. Help is appreciated.
Thanks in Advance
Last edited by a moderator: