When we initially made the AddProductButton on click event using VBA to perform dlookup's for notes, istaxable etc... it never worked for me so I just added those fields to the combo box & it worked great. Now that we're adding more data to be looked up I'd really like to get to the bottom of why the VBA dlookup's aren't working. Here's a list of all the combinations I've tried:
The field formats I'm looking up are all currency or number, no text fields involved. I'm looking up UnitCost in the ItemXVendorT since I have a many to many relationship with products, vendors & their prices. I've scanned forums for many hours without success. Are there any common issues that I may be overlooking? Any help would be much appreciated :)
Reply from Alex Hedley:
If you Debug.Print your ItemCombo what value are you getting? Is your ItemID a Number Field If it is text you would need "ItemID= ' " & ItemCombo & " ' " (i.e. wrapped in quotes) Does your ItemXVendorT have values that match your ItemID With it being a Junction Table are you likely to only have 1 ItemID
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 311.
