Hi,
I'm creating a single user database that will have a preference form. On this form there will be a number of check boxes (one for now will do) that will define popup forms to be toggled on or off. The preference form's record source is a table that has a single yes/no field (for now). I have created a startup form that checks to see the value entered in the yes/no field and either displays the popup form, or not. That part I can get to work. My problem is this, I open the preference form via the switchboard. When the form loads, the current status of the field isn't being determined (the check box is greyed out until you click on it to alter it's value). When you do click on the check box, then another record is added to the field - where I simply want to change it's value. If I open the form from the database view, then all is ok. The value is read from the field and you can alter it with the checkbox no problem. I have added some logic to the activation of the form that checks the current value of the field and changes the check box accordingly, having previously simply specified the checkboxes Control Source.
I'm starting to go round in circles, with what might be a simple task. Any pointers or examples would be greatly appreciated.
Keith
I'm creating a single user database that will have a preference form. On this form there will be a number of check boxes (one for now will do) that will define popup forms to be toggled on or off. The preference form's record source is a table that has a single yes/no field (for now). I have created a startup form that checks to see the value entered in the yes/no field and either displays the popup form, or not. That part I can get to work. My problem is this, I open the preference form via the switchboard. When the form loads, the current status of the field isn't being determined (the check box is greyed out until you click on it to alter it's value). When you do click on the check box, then another record is added to the field - where I simply want to change it's value. If I open the form from the database view, then all is ok. The value is read from the field and you can alter it with the checkbox no problem. I have added some logic to the activation of the form that checks the current value of the field and changes the check box accordingly, having previously simply specified the checkboxes Control Source.
I'm starting to go round in circles, with what might be a simple task. Any pointers or examples would be greatly appreciated.
Keith