Combo Box (ACC 2K)

Topic

New Reply

I have a field called AppStatus with combo boxes (NEW, DSS, REDET etc.) field called EAPP with a data type Y/N. The only time EAPP checked yes is when the user select NEW or REDET. How can this be accomplished and where exactly ?

Thanks,
DD

Reply | Quote

Replies

In the after update event for the AppStatus field put this code:

if ((me![AppStatus] = "NEW") or (me![AppStatus] = "REDET")) then
  me![EAPP] = true
else
  me![EAPP] = false
end if

On the form you might also disable the EAPP control so that the user can’t put the wrong thing in it.

Reply | Quote