Hi Crystal,
I will reply inline below.
Thanks Crystal
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, December 10, 2015 3:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Issue with Events not firing in subform
Hi Glenn,
What are the LinkMasterFields and LinkChildFields properties, if any?
[Glenn Lloyd >>>] No Link fields. The subform in question is unboud.
How are you synchronizing data in the subforms?
[Glenn Lloyd >>>] No data to sync in this form. There are only two controls, both unbound combos.
What is the code you are using to switch?
[Glenn Lloyd >>>] In the Open event of frmInterviewViewer:
Me.fsbInterview.SourceObject = "frmInterviewSelector"
In the click event of the terminating subform's command button:
Me.Parent.fsbInterview.SourceObject = "frmInterviewSelector"
Are you using any navigation controls? ... or doing this because you don't want to?
[Glenn Lloyd >>>] No navigation controls, just using command buttons as above
from you second email: 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?
No Control source: RowSource is
SELECT tblOutbreaks.OutbreakID, tblOutbreaks.OutbreakNumber AS [Outbreak Number], tblOutbreaks.OutbreakEventStart AS [Start Date], tblOutbreaks.OutbreakEventEnd AS [End Date], tblOutbreaks.OutbreakEventName AS Name, tblOutbreaks.OutbreakEventLocation AS Location FROM tblOutbreaks UNION SELECT 0,"<Select Outbreak>" ,null,null,null,null FROM tblOutbreaks ORDER BY tblOutbreaks.OutbreakID;
The first time the frmInterviewSelector is assigned, events fire as expected. It's when I reload it that Events are not triggered.
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
Posted by: "Glenn Lloyd" <argeedblu@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar