ACCESS FEED: RE: [MS_AccessPros] Issue with Events not firing in subform

Sabtu, 12 Desember 2015

RE: [MS_AccessPros] Issue with Events not firing in subform

Hi again Crystal,

I have found a solution to my issue. Part of the problem as a mis-diagnosis on my part (incorrect bound column in the combo.

Thanks for taking a look.

Glenn

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, December 10, 2015 4:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Issue with Events not firing in subform

oh, and what is the SQL for the RowSource of the combos that don't want to behave? And the ControlSource? Does the code compile ok?

instead of using Open, what about using Activate? or Load?

thanks

warm regards,
crystal

~ have an awesome day ~

On 12/10/2015 1:57 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

Hi Glenn,

What are the LinkMasterFields and LinkChildFields properties, if any?

How are you synchronizing data in the subforms?

What is the code you are using to switch?

Are you using any navigation controls? ... or doing this because you don't want to?

warm regards,
crystal

~ have an awesome day ~

On 12/10/2015 1:28 PM, argeedblu@gmail.com [MS_Access_Professionals] wrote:
I use an unbound form with a subform control as a shell to display a number of different subforms. I use VBA to swap the content forms using the subform control's SourceObject property,

One of the content forms has two combos on it. The first time this content form is assigned to the subform control, it works normally, However, if I swap in a different form and the later swap the first form back in, none of the subform's events appear to fire. The form loads alright but the combo does not display the correct text. The open event should assign a value to the combo but the open event is not triggered the second time I assign this form to the suborm's SourceObject.

I have put breakpoints on other events (load, activate, current) but none of these fire either. I have decompiled, compacted, re-compiled all to no avail.

Any suggestions?

Glenn