G
Guest
I have a form with a Tab control. The Tab control is a collection of
subforms. On the main form is a combo box. I would like to set the Addrecords
to true or false and the visiability of a button on a subform of the Tab
control based on the whether there is a record in the table linked to the
subform that correspons to the value in the combo box of the main form. After
Update of the combo box I requery the subform me.subform.requery successfully
, but am unable to set the addrecords and button.visible. Tried
forms!tabcntl("Subformname").forms.allowadditions=false and various
permutations; I susoect I don't have the right reference. Have tried to set
it successfully on click of a field on the subform, but need to click
there...hasn't worked on sub form current, ect. Any help would be appreciated.
subforms. On the main form is a combo box. I would like to set the Addrecords
to true or false and the visiability of a button on a subform of the Tab
control based on the whether there is a record in the table linked to the
subform that correspons to the value in the combo box of the main form. After
Update of the combo box I requery the subform me.subform.requery successfully
, but am unable to set the addrecords and button.visible. Tried
forms!tabcntl("Subformname").forms.allowadditions=false and various
permutations; I susoect I don't have the right reference. Have tried to set
it successfully on click of a field on the subform, but need to click
there...hasn't worked on sub form current, ect. Any help would be appreciated.