Conditional Formatting

[Ann]

I'm trying to color the text boxes I have on a form and a subform.

I have a form called frmDRSJobs and a subform called subfrmDRSJobsByOperators.

If the [dtmClosedDate] (this is on the main form) is entered all the fields
on the form and subform need to be a different color showing this is a
completed job. I didn't have a problem with the main form using the
conditional formatting option but when I'm on the subform I don't know how to
refer back to the main form. I tried a number of different things, Parent,
Me, using the form name and though I don't get an error nothing happens. Can
someone tell me how to refer back to the main form when using the conditional
formatting option? Thanks for the help.

 

[Clifford Bass]

Hi Ann,

Try using:

[Forms]![frmDRSJobs]![dtmClosedDate]

Clifford Bass

 

[Ann]

That did it!! Thanks so much for the help.

Hi Ann,

Try using:

[Forms]![frmDRSJobs]![dtmClosedDate]

Clifford Bass

I'm trying to color the text boxes I have on a form and a subform.

I have a form called frmDRSJobs and a subform called subfrmDRSJobsByOperators.

If the [dtmClosedDate] (this is on the main form) is entered all the fields
on the form and subform need to be a different color showing this is a
completed job. I didn't have a problem with the main form using the
conditional formatting option but when I'm on the subform I don't know how to
refer back to the main form. I tried a number of different things, Parent,
Me, using the form name and though I don't get an error nothing happens. Can
someone tell me how to refer back to the main form when using the conditional
formatting option? Thanks for the help.

 

[Clifford Bass]

Hi Ann,

You are welcome! Glad to hear it worked.

Clifford Bass

 

[Ann]

Hi Cliff,

I ran into a clitch and I wonder if I could get a little more help. The
conditional formatting works when I open the form and show all the records
then all the textboxes in the main and subforms are green. But, if I'm
entering a new closed date that is greater then the open date my conditional
formatting won't change the color for the textboxes on the subform until I
move off the record and then go back again. Is there a way to make it happen
at the time the date is entered like it does for the main form?

Here is the expression in the conditional formatting on the textboxes of the
subform.

([Forms]![frmDRSJobs]![dtmClosedDate]>=[Forms]![frmDRSJobs]![dtmOpenDate])

 

[Clifford Bass]

Hi Ann,

It sounds like it is related to the record being or not being saved.
That is often when some other processing gets activated. You might try a
refresh on the subform in the After Update event of the dtmClosedDate:

Private Sub dtmClosedDate_AfterUpdate()
' Not sure of exact format of the sub declaration - create it using the
wizard

subfrmDRSJobsByOperators.Form.Refresh

End Sub

Clifford Bass

 

[Ann]

That worked. You're really great to help me out...thank you!

Hi Ann,

It sounds like it is related to the record being or not being saved.
That is often when some other processing gets activated. You might try a
refresh on the subform in the After Update event of the dtmClosedDate:

Private Sub dtmClosedDate_AfterUpdate()
' Not sure of exact format of the sub declaration - create it using the
wizard

subfrmDRSJobsByOperators.Form.Refresh

End Sub

Clifford Bass

Hi Cliff,

I ran into a clitch and I wonder if I could get a little more help. The
conditional formatting works when I open the form and show all the records
then all the textboxes in the main and subforms are green. But, if I'm
entering a new closed date that is greater then the open date my conditional
formatting won't change the color for the textboxes on the subform until I
move off the record and then go back again. Is there a way to make it happen
at the time the date is entered like it does for the main form?

Here is the expression in the conditional formatting on the textboxes of the
subform.

([Forms]![frmDRSJobs]![dtmClosedDate]>=[Forms]![frmDRSJobs]![dtmOpenDate])

 

[Clifford Bass]

Hi Ann,

Good! You are welcome.

Clifford Bass