I was wondering if there's a simple way for this:
I have a form with two comboboxes and depending of what you select in combox1 the data that will appear in comb2 will change.
Everything works fine if you use it once but if I change the value in combobox1 when I click in the combobox2 instead of getting a new set of values i get the same as before. If I close the form, reopen it. It works again but only for the first value.
I know it would be easy with vb code but I reckon that access probably has simple way of doing this, any chance of updating the form or anything like that?