I have a form with 3 unbound boxes: "project name" "project number" and "company name" I have a subform that updates when data is entered (or picked from a list) into any of the boxes, that way you can find data by knowing any of the 3 criteria. The subform updates properly but I can't figure out how to update the boxes if one is updated, i.e., if I enter the project number it would be nice if the project name and company name would also update. Any help would be appreciated.
Thank you. I believe this locks my project name and company name into the value of the project number. I would prefer to be able to look up the data by any of the 3 boxes, project name, number or company name. Or am I not putting in the code correctly?