combobox message 1

[swtrader]

On a sub-sub form, I have a combobox. Double-click opens modal pop-up form listing all items that combobox lists. The pop-up form has an extra field, Archive?, for each record. The user can then select a record to archive -- thus 'hiding' it from view in the combobox.

Once the modal form is closed, the focus returns to the combobox on the sub-sub form and a requery is executed.

Herein lies the problem. I want to 'educate' users as to the availability of 'new' modal form. )After a week or two, I will delete the message box...assuming that the users will 'get it'.)

I have tried several different ways to trigger opening the message. When I use the combobox control's OnFocus Event to display the message, the message is displayed when the Main Form opens. Same is true of Enter Event. This happens even though the focus on opening of the main form is on a control in the main form.

I need the message to appear the first time the focus is on the sub sub-form combobox and NOT re-appear after the user has double-clicked the message box to open the modal form, then closed it (thus returning to the combobox).

Thanks.

swtrader
Dallas, TX

 

[MajP]

forms open from the inside out. The subform loads first. So focus goes to the control in the subform, then the control on the main form. Ensure the first tab control of the subform is not the combbox

 

[swtrader]

Thanks, MajP --

Pointed me in the right direction. For some reason, I had a GoToControl in the Main Form OnOpen Event...that effectively triggered the GotFocus Event on the sub sub-form. Cleaned it up and it works as intended.

I've worked with Access a long time. Have never understood why forms open inside out. Do you have a short explanation?

 

[MajP]

I do not know why but a common but here is the info:

http://office.microsoft.com/en-us/access/HP051867611033.aspx

A trick is to save the form with no SourceObject in the subform control. Then assign it along with the LinkMasterFields LinkChildFields after the main loads such as the on current event.