My Data base has a form (a unique row of data, with FileNo that is the Primary Key of the record source) that the user enters various information. One of the items they would like to enter is a status. They would like a Pull down with some pre-canned responses, but would like to be able to enter free text (not on the pull down list). There could be multiple status's entered so one day they could enter a value from the pull down and the next day they would enter free text. So there would be a new row created each time they entered a status.
I would like this to be on the existing form, perhaps use a subform? And I want to make sure the status they enter links to the FileNO on the form, so that I can later use this on a report for each record.