Here is the database. I thought I had the right OnCurrent expressions, but could be wrong. My first version of the form used two continuous subforms as you suggested. It worked fine mechanically, but is not as easy to use. I have not used a treecontrol, so if you have a suggestion after viewing...
I have an Orders form, without any underlying related tables.
Located in the upper half of this form, I have a sfrmOrders in datasheet view with a ssfrmOrderDetails as a subform embedded in it. On the lower half of the form, I have a sfrmOrderProcessing in single form view.
The goal is for...
Is it possible to use If..Then to change control colors on a continuous form? It works for a single form, but using a checkbox for a value to color other controls sets all controls in a continuous form the same.
Example:
If Me.chkInactive.Value = True Then
Me.Firstname.ForeColor = vbRed...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.