Hi,

I have a form and a subform. When I open the form, I want do display messages in a text field. The messages depend on the content of the subform. For example:

Message1 will display if the total of items in the subform are flagged as sold.
Message2 will display if the event is happening in the current month.
and so on...

I cannot find the right event to have the messages display. I tried 'on activate', 'on open', etc... of the form and subform, but the messages don't display. Right now, I have my validations done on the 'get focus' event of the first field that gets the focus in the subform, but unless we go to another control and come back to the first control, the messages don't display.

Note that in the main form, there are no fields that get a focus.

Can you please help me!:(

I don't know if this can be adapted to your situation but here is something we use to display a message on a form for a 2nd letter process.

It evaluates a couple of controls on the form and depending on the situation, it displays a message to the user. It placed in a text box.


=IIf([needssecondletter]<>False And Not (IsNull([maildate2])),"Letter was Returned and Remailed",IIf(Not (IsNull([maildate2])) And [needssecondletter]<>True,"Letter Requested during Phone Contact",""))


John