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!:(