Dugantrain
I Love Pants
- Local time
- Today, 05:53
- Joined
- Mar 28, 2002
- Messages
- 221
Continuous Form Independence Question Re-revisited
Hi all,
I have a Bound Continuous Form with 7 text boxes and one Combo Box. The effect that I'd like to have is, if the Record is New, then all of the Text Boxes will be Disabled and can only become Enabled once a Selection is made out of the Combo. If the Record is not new, then all of the Text Boxes should be Enabled. So, if you have two committed records, both records will have all textboxes Enabled and a third New Record will have all textboxes Disabled. New Record's text boxes become Enabled once Combo selection is made. Can Conditional Formatting or some VBA handle this sort of Continuous Form Independence?
Hi all,
I have a Bound Continuous Form with 7 text boxes and one Combo Box. The effect that I'd like to have is, if the Record is New, then all of the Text Boxes will be Disabled and can only become Enabled once a Selection is made out of the Combo. If the Record is not new, then all of the Text Boxes should be Enabled. So, if you have two committed records, both records will have all textboxes Enabled and a third New Record will have all textboxes Disabled. New Record's text boxes become Enabled once Combo selection is made. Can Conditional Formatting or some VBA handle this sort of Continuous Form Independence?
