enable or disable based on DLOOKUP function

  • Thread starter Thread starter anj
  • Start date Start date
A

anj

Dear All
Thanks in advance!
I am trying to enable or disable certain opton group based
on the value filled with "dlookup" function on a control
other than the criteria. Suppose I have an option
group "AA", criteria "BB" and few other control
like "CC","DD", "EE" and so on. I want to enable and
disable "AA" based on the value filled on control "CC"
let's say if value "E" filled then enable or if value "D"
filled then disable "AA" and these values are filled after
entering specific criteria value on criteria field "BB"
with "dlookup" function from a related source table

How can I do this? I have tried using event procedure of
control "CC" but couldn't succeed.

Thanks!
 
On the event After Update of field CC asign a value to BB
by using Dlookup, and than according to the value you got
with the dlookup enable or disable the group AA.
On the load form activate the sub AfterUpdate of CC and
that will assign the right value when you load your form.
 
Back
Top