If field then checkbox and enable
in [Form]
|
From: deb on 27 May 2010 17:56 On my form called f015KeyMilestones(continuous form) I have a field called KeyMilestonesSubID. 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 Thank you -- deb
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 disabled 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 ie private sub PassedQGDt_gotfocus() if QgateNA.value = false then msgbox you cannot use this control end if end sub Hope this helps Regards Kelvan
|
Pages: 1 Prev: Using 'like' on a user prompt Next: Add code to CloseButton |