Forget to mention that each combo box is dependent on the other...
translation:
If I choose Germany in cboPlaces that needs to pull the products from tblGermanPrices for the cboProducts and then pull the respective sell type from tblTransactionType...
Hope that is clearer.
Thanks.
UCLABRUIN...
Hello all,
Thanks for the past replies.
I am working in Access 2000...
I have a frmProduct where I have three combo boxes showing Country, Product and How to Sell respectively. Also on the same form I have a ADD button which should add these items(the selection I made from the combo boxes)...
I wanted to further extend this question, I was wondering what if this combo box wasn't on a form but on a regular excel worksheet, would I still be able to connect to a particular table and a field to populate that table?
I have already tried the range and ODBC thing. I am creating a tool that...
yikes...my co-workers want to have where they can just update that field in the access table and boom the changes take place in excel's combo box...so if tblProducts change then it not a big deal.
Any ideas?
Linked sheets are not allowed. Thanks for your help. Can't tell you how much I need...
Thanks for your answer...i am doing that now. I got another issue lurking. I put a combo box (drop-down kind) on my excel sheet. The source of that combo box should be a Access 2000 table called tblProducts. What do I do?
What code do I need to write in VBA?
Can't seem to get thru this hoop...
Hi,
Can anyone tell me how to connect a Excel Workbook 2000 with a Access 2000 db? I am new to the field...need help.
I have various tables in the Access db from which I need to extract data as well. I really would appreciate some advice. Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.