I don't know if my problem is syntax or what.
In a subform, I have a combo box, which shows a code and its description. When the user selects the code, I want the description to show in the next field on the form, which is unbound (I don't want to store the description, as it is long, just show it).
I also have a simple query that will find the correct record, based on the code selected in the form, and return the description.
I've tried several ways, unsuccessfully, to get that description to show up in the unbound control.
I'm sure this can be done, but I'm stumped at the moment. Thanks in advance.