Setting a control on a combobox

[mooneye]

I have a combobox which is used to indicate a records staus. I am trying to set a control on this combobox so that it may only have a status of 'closed' when a particular field has information in it.

 

[pdldavis]

Hi, might look cleaner using a text box, but something like
this would work as the control source:

=iif([yourstatus] = "status1", "Closed","&quot

Hope that helps.

 

[Pipewelder]

in the "Particular Field" after update event, use code similar to below.

If not isnull(particular field) then
comboboxcontrol="closed"
else
comboboxcontrol="Open"
end if

Some better suggestions may come up from others but this may get you started.


Good day