Conditional format Main form field from subform data

[sbrem00]

Hi All,



I have an access database which has a subform that holds dates of community groups such as the insurance renewal date. I would like to have a message displayed on the main form when this date has expired using conditionlal formating to change the colour of a text box with a default value.

Then once a new insurance date is entered (on a seperate field) it will ignore the old one and use the new date for the condition formatting.

Does anyone know if this is possible?

Thanks.

[NTC]

well depending on what you mean in your post;

it is easy to conditional format a date field - all your Access textbooks cover this - put the form into design view, right click on the field - and then set up the condition (which would be less than Now())

you mention a message display - - which I interpret as conditional too - and so it is not clear if you want a generic label toggled visible or a specific messagebox displayed. Either is possible. If the dates are all in a subform then one might use a DCount of that record set just to see if any records are expired relative to Now()....or a DLookup. These are two methods of VBA you might want to explore as a technique to trigger your message.

Hope it helps.