Hi,
I'm using Access 2010 and are working on a Web Database on Sharepoint/Access Services.
I'm trying to figure out how to get cascading comboboxes to work but can't get it to work, hopefully you guys can help =)
I have two tables:
tblcustomers
ID - Customer - Contact - City - Country - Language
1 - Big Customer - Contact name - - -
tbllocation
ID - City - Country - Language
1 - London - UK - ENG
2 - Paris - France - FRA
3 - Liverpool - UK - ENG
What I would like is some combo boxes where I first can select City and the second third combo boxes should then have the corresponding values based on the first selection. It doesn't have to be several combo boxes, it might be one combo box where I select city and the country and language values beeing populated into text boxes.
The values should then be inserted into fields in the tblcustomers.
Looking forward to hear from you and really appreciate your help
Thanks,
I'm using Access 2010 and are working on a Web Database on Sharepoint/Access Services.
I'm trying to figure out how to get cascading comboboxes to work but can't get it to work, hopefully you guys can help =)
I have two tables:
tblcustomers
ID - Customer - Contact - City - Country - Language
1 - Big Customer - Contact name - - -
tbllocation
ID - City - Country - Language
1 - London - UK - ENG
2 - Paris - France - FRA
3 - Liverpool - UK - ENG
What I would like is some combo boxes where I first can select City and the second third combo boxes should then have the corresponding values based on the first selection. It doesn't have to be several combo boxes, it might be one combo box where I select city and the country and language values beeing populated into text boxes.
The values should then be inserted into fields in the tblcustomers.
Looking forward to hear from you and really appreciate your help
Thanks,
