How? Multiple value fields displaying in another form

[Elvli]

By means of a multiple value checklist the Field: "Problem" can be selected (marked).


The Problems: Severe, busy, slow, level2 are selected. The other fields not.

The multiple value field information is stored in the table beginsituation in the form Beginsituation. This stored (selected fields only) information I want to be fetched from the table beginsituation and shown in the multiple value checklist in another form called Progress. The user can than change the selection via the multiple value checklist if the user wants this and this information will be stored in the table: "Progress". However I could not get the in the previous form (Beginsituation) selected values in the multiple value checklist.

How can I do this? Via VBA?

[June7]

Didn't understand most of that.

You are using a multi-value field named Problem? Values can be severe, busy, slow, level2? Why would more than one of these be selected for the same record?

What do you mean by 'The other fields not.'?

What do you mean by 'This stored (selected fields only) information ...'?

If you want to store data in table Progress then bind form to that table. What is the multi-value field in table Progress?

[Elvli]

June 7, Are you an experienced access vba programmer? Can I mail you the source code of the multiple value problem part of the Access application we have made?
The main problem is that we are using multiple value selection fields where you can select multiple values from the list (standard access function) that we let Access store in a table. After that we want to retrieve these values from the table and let the previous selected values be shown in the multiple value list in another form with another table connected to the form after we have made a query to retrieve these values.
We are already busy solving this problem for half a year now.

[June7]

I have experience in vba programming. You can attach files to post. See instructions at bottom of my post.

I refuse to use multi-value fields because of their issues.

Certainly a query can expand the multi-value field, beyond that I have no idea what you are trying to do. This phrase "values be shown in the multiple value list in another form with another table connected to the form" makes no sense to me.