From: deb on 27 May 2010 17:56
On my form called f015KeyMilestones(continuous form) I have a field called
How can I do the following..
If KeyMilestonesSubID =12 then the checkbox called QGateNA is checked
If QGateNA is checked (user checks or the above) then the field called
PassedQGDt is enabled
From: Lord Kelvan on 27 May 2010 21:24
Is QGateNA a bound control because if it isnt then you cannot do it,
as continuous forms are a devil of a thing to do anything with.
If it is a field then again you need to check it when you create the
record that is attached to KeyMilestonesSubID. Though if you cannot
do this you will need to loop through all records in your form looking
for KeyMilestonesSubID = 12 and then set the value of the field
QgateNA to true.
As for enabling and disabling again you cannot do it as if you enable
on button on a continuous form all are enabled and the same for
What I do when I want to do this is I add some code to the button or
field that if someone selects this field or clicks this button it
tells them it cannot do it
private sub PassedQGDt_gotfocus()
if QgateNA.value = false then
msgbox you cannot use this control
Hope this helps