Hi there. I'm an advanced beginner at Access, but if someone could provide direction to me on the following issue that would be great. I would like to change an inherited value in a combo box in a datasheet form when the data in the source table changes. For example, if the source table has an option of "ABC" and the user has already selected that in the datasheet form, then if the user changes the name of that option to "ABCD" then I would like the dropdown to automatically change from "ABC" to "ABCD". The way it works now is that the user needs to go back to dropdown and select "ABCD" manually to overrise the inherited value of "ABC". This is obviously time consuming when there are hundreds of records.
Any advice would be most appreciated?
Thanks.
Josh