I have a Main form that has an address subform. I have a combo box on the main form that selects address records. I know that normally you should enter the address information in a seperate popup form and then return to the main form, but I was trying to avoid having to use popups by enabling/disabling the controls ont he subform.
The address record is made up of (unit, streetaddress, city, prov, postal)... the combo is tied to streetaddress. I was hoping to:
- in the Open event of the form, disable all the controls on the Address subform (done, easy)
1. in the notinlist event of the combo, enable the controls on the subform ( i think i can make this work)
- add an edit address buton for editing exisiting records (done, easy)
2. when the subform looses focus the controls on the subform are again disabled ( i cant figure out how to do this without coding the GotFocus event of each other control on the form to disable the subform controls... this [censored], hoping to find a better way)
Thanks guys, 1 and 2 are really what I need help on.