Well, I didn't import "everything" exactly. I used the wizard to leave off
the duplicate information.
The spreadsheets contain information about candidates that we have assessed
at a consulting firm. There is a lot of data for each one (raw scores,
percentiles, other rankings) and there are different scales they could be
ranked on, based on their position. We call that the "Report Form" in the
spreadsheet and there are 12 possibilities. When I imported the data, the
lines of data that had a value for that column have that report form name.
However, I moved this data to Access because last week my assistant made a
sorting error and almost destroyed 2 years worth of data. I want her to use
Access from now on to enter the data.
So, to make sure we don't have spelling errors, etc., I want a drop down for
the Report Form entry. But, in my form, if I change what is now a text box to
a list, there is no data in the entry anymore. Is there a way, other than
just creating a new entry on the form and leaving the old one there as well,
to keep the data I imported, plus use a list to add new data?
Thanks,
Kim