I have a table setup like: ID, Code, Description
Then I have a combo-box that when the user selects a record, a text box is populated with the Description from the table and the ID is stored in the form's record source. But then we want to allow the user to select ANOTHER record in the combo box and have that record's description added to the end of the previous one. And then have that ID field added on to the stored first ID field. I guess then the stored value in the record source has to be text, right?
Can this even be done?