Multi-use, conditional locking combobox

[rdulanski]

I've been asked to make a box on a form with a drop down so I think it has to be a combobox. It must
1) show the Field value from the Main table if the field isn't null and
2) lock the box so it can't be changed;
or
3) allow selection of a value from a drop-down if it is null and
4) save that value for auditing without writing to the Main Table.

I don't think it can be done so I created
1) a locked Text box to show the Main table value and
2) an unlocked Combobox for selecting a value from the drop-down.
My thinking is that the selected value should be sent to a Temporary table for future processing.

Can I do conditional locking?
How do I allow that drop-down selection and then send the data to the Temporary table?
When I send that data, how do I take other field values from the page to form one record to send to the Temporary table?

Thanks so much for your help.

 

[Galaxiom]

ConditionalFormatting can Enable a control based on the content of the control or an expression referring to other controls.

You should be able to do it with just the combo.

 

[gemma-the-husky]

you can also test the state in the forms current event, and lock/unlock the combo box accordingly.


if isnull(mycombox) then
....
else
....
end if

 

[Galaxiom]

The advantage of the ConditionalFormat technique is that it works on Continuous Forms. The code technique is only suitable for a Single Form.