Extract/Populate Data

[tylerg11]

I have a form which is based on a query which is based on a table. I have a text box in my form which is called Preferences and it contains various data, comments, etc. I have a list of about 5 different values that I want extracted from the Preferences field and populated in a new field. Does this have to been done at the table level? Or can I accomplish this with a query or even within the form itself?

[June7]

This textbox is bound to a multi-value field in table? Multi-value fields are nasty devils, I REFUSE to use them. See http://office.microsoft.com/en-us/ac...001233722.aspx