Rod-
Ah, it was your use of "split form" that threw me off. I should have
figured out you meant another form with its own subform because you cannot
use a true "Split Form" as a subform and still see the split part.
You need to go one level deeper:
Me.F_Correspondence.Form!F_CorrespondenceDS.Form!NameOfControl
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rodbevill
Sent: Monday, December 03, 2012 3:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Referencing control on subform to requery
Hi John, Thanks for the reply. I am still have the problem and I think is
has to do with the fact that I am using a split-form in the tabctrl. The
form name of the split form is F_Correspondence (selection type:
Subform/Subreport) with two forms making the split. The upper form is
frmCorrespondence (where the controls occur) and the bottom form is
F_CorrespondenceDS (datasheet view). As a note I am trying to use the
split-form design of A.D. Tejpal which is the only split-form I found to
work within a tab-control.
Any further suggestions would be greatly appreciated.
Rod
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...>
wrote:
>
> Dear rodbevill- (name?)
>
> Assuming you'll be running Requery in code behind the outer form
> (perhaps in the Current event), you would reference the controls on
> the subforms like this:
>
> Me.Subformcontrolname.Form!NameOfControl
>
> Note that Subformcontrolname is the name of the subform control, NOT
> the name of the form inside the control - though they are often the same.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications SQL Queries for Mere Mortals
> http://www.viescas.com/ (Paris, France)
>
>
>
> -----Original Message-----
> From: rodbevill <desertscroller@...>
> Reply-To: <MS_Access_Professionals@yahoogroups.com>
> Date: Saturday, December 1, 2012 5:25 AM
> To: <MS_Access_Professionals@yahoogroups.com>
> Subject: [MS_AccessPros] Referencing control on subform to requery
>
> The db that I am developing (Access 2010 on Windows 7) consist of a main
> form with a tabcontrol. Each tab consist of a split form. Within the
> split form are combo-boxes with data based on a saved query. The issue
> is requerying the row source for the various combo-boxes when the record
> on the main form changes. Each of the tabs contain different data from
> the db tables. Each tab only uses one table. Each tab is linked to the
> main form thru an id field.
> Query definition for the combo-box row source:
> SELECT tblParcel.lngParcelID, tblParcel.lngParcelNum
> FROM tblParcel
> WHERE (((tblParcel.lngTPTID)=GETTPTID()));
>
> The function GETTPTID() retrieves the ID which is updated every time the
> main form updates to a new record.
> I am trying to use the TabCtl On Change to initiate the requery for the
> combo-box. Tried several approaches at a loss. The combo-box is used to
> list the currently identified property parcels used when sending
> correspondence. Not sure if I have explained the issue well enough? Any
> suggestions would be greatly appreciated.
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar