Query about Option String

sunct

Hi,

I have a doubt about getting options from a field to an option variable. This is the scenario -

I have an Option field with 5 options in a table. Now I have another form where I declared an Option vaiable and made it as the Source expression of a text box. Ideally, we have to provide the option string for the variable for viewing the dropdown options in the textbox. But my requirement is that while opening the Form, this option variable has to get all the options available in the above mentioned Option field in the table. If I add new options to the field in the table, they have to be reflected in this option variable of Form. I dont want to make the table as the source table for this form because I just need the options in the text box and other processes are independent of the table.

Is it possible?

Thanks in advance

kine

No, you cannot change the options in run-time.

matttrax

Why are you using an Option field? Just use a Code field with a TableRelation to a new table where you store the options.