Extract certain values from field

[tylerg11]

If a value in the Preferences field on the form matches "GRA" or "Geo-T" then it will be extracted from the Preferences field and a new field called Types will be populated with that data. Almost like a cut/paste function if certain criteria are met.

[Robeen]

So - if Preferences has 'GRA' [for example] - then 'GRA' will be put in the Types field?

[tylerg11]

Yes. Extracted from Preferences and populated in Types.

[Robeen]

A query might be good for this. You ok with that?

[Robeen]

I ran this quick query that I thought you might be able to use as a skeleton on which to flesh out your own query to build your Form on.

Create a new query.
Select all the fields you will need from your table [the fields that are on your Form].

Then - in a new field in the Query Type something like this:

 
DupeField: IIf([Preferences] In ("GRA", "Geo-T"),[Preferences])

If the [Preferences] field of the current record has one of the values ("GRA", "Geo-T") - then that value will be written to the new field that I named 'DupeField'.

Once you have this query working the way you need - you can go into your Form in design view and change the 'Record Source' in the Property Sheet - Data tab. Then your Form will get all the data from the Table - Plus the duplicated values from the Preferences field in the new field 'DupeField'.

Hope this helps.