Auto-updating of a multivalued field from another single valued field.

[access12]

How can more than one options can be selected in a multivalued field by entering some data in a single valued field. Will somebody please provide help in this regard.

A single valued field can be updated by entering data in another singled valued field by using SetValue in a macro. However, the same method is not working for updation of a multivalued field from a single valued field.

Any one please to help me.

 

[Uncle Gizmo]

When Microsoft came up with multi value fields I was warned that they would cause problems, and should be avoided. I would guess "the others" were warned and avoid them as well. (There will always be someone who has become an expert on them and thats the person you need to find)

Failing finding the guru who knows, then you may have to reconstruct your db in a more traditional manner.

 

[access12]

OK brother. Then who you may suggest to solve this problem.

 

[Uncle Gizmo]

Theres a set of Links HERE:- Multi Value Fields Links

I update them from time to time..

 

[arnelgp]

can you tell more of what are you doing what form, fields, what are the valuesto put in mvf