If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If field then checkbox and enable
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 |
#2
|
|||
|
|||
If field then checkbox and enable
Is QGateNA a bound control because if it isn’t 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 |
Thread Tools | |
Display Modes | |
|
|