Solved Need help with form reference/ conditional formatting (1 Viewer)

[AGNewton5]

I have a Form that I am wanting to reference the entered date in a texbox [jtblPositionTraining]![DateOfCourse] to the date that the course was last updated, which is in a different table [tblTraining]![RevDate]. I am wanting to use conditional formatting to show when [jtblPositionTraining]![DateOfCourse] is dated older than [tblTraining]![RevDate]. Preferably get the textbox background of [jtblPositionTraining]![DateOfCourse] to be green when it is newer that the RevDate and red when the date is older than the RevDate. I was wanting to make the reference not visible afterwards on the form (something I think I can do). The database that I have can be shared if needed, because I am not sure if the info that i provided is even helpful.
Use Administrator Form to enter
Password 1Newton1
The form is frmPositionsandCourses

 

[bob fitz]

Posting a copy of the db would help

 

[CJ_London]

perhaps use the dlookup function

field value is....less than....dlookup("RevDate","tblTraining")

 

[AGNewton5]

Posting a copy of the db would help

I have added the DB, Thank you!

 

[AGNewton5]

perhaps use the dlookup function

field value is....less than....dlookup("RevDate","tblTraining")

Is there a way that I can do this and reference a specific RevDate on tblTraining based on the record that is being added on the form? This is almost doing what I am wanting to do.

 

[arnelgp]

I the Date field has already Conditional Formats.
i added an Unbound textbox to the right and applied the
conditional format to it.

i also added the training revision date to your form but hid it.

 

[AGNewton5]

I the Date field has already Conditional Formats.
i added an Unbound textbox to the right and applied the
conditional format to it.

i also added the training revision date to your form but hid it.

Thank you arnelgp! You are a lifesaver. I have been fighting that for too long.

 

[arnelgp]

you're welcome
you should add Label to the unbound textbox that will explain its purpose.

 

[AGNewton5]

you're welcome
you should add Label to the unbound textbox that will explain its purpose.

Will do. Thank you for your help!