Dear All,

Can I select an option of a Multichoice field ( built with a lookup funtion as a result of a relationship between two tables), using setvalue function?

Please see attached example what I'm trying to do

The ideia is to click over a field and select that value into a Multipchoice Drop Box. The several records values into these DropBoxs are the same of fields values of subform.

If the destination field is not this type of field ( Multichoice based in a lookup Function ), there's no problem , setvalue funtion works very well.

Thanks 

Afonso

We are sorry, but we can't really grasp what you are trying to do.

The Word Document is "muddled" so the image is only half showed and the text is also behind it. When uploading try to convert to image or even better, include a small application as it is easier to deduct what one try to do.

Most people (including us) are more than willing to give a pointer but can't invest a lot of time in solving others problems so when asking for help try to make it as easy as possible so people have the time to do so.

Mutliboxes can be awkward but they should accept values set with SetValue() - Just tested to make sure. 

The problem however may be visible updating so try to call RefreshForm() after setting the value.

RefreshForm() will simply refresh the dataset in the form and is non invasive i.e. it will not overwrite, read or look up any values that is not part of the dataset already.

RefresScreen() will re-read the saved data from the table.

One could argue that the naming is 180 degrees wrong but as RefreshScreen() has been around since 1990s and RefreshForm() is a 8.x function it is a little late for change ;-)