Re: [MS_AccessPros] passing id from subform to popup form

 

I guess I missed one thing. Once I save the record in the popup and close the form I need to refresh the underlying subform (frm_converyance_list).

Forms!frm_main!Child1.Form!ChildSettings.Form.refresh ???? 

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

---

From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, August 5, 2015 1:44 PM
Subject: Re: [MS_AccessPros] passing id from subform to popup form

 

Art-

It looks like the value you want to get is two subforms deep.  Maybe something like:

Forms!frm_main!Child1.Form!ChildSettings.Form!UnitID

That says:

Go to the Child1 control on the farm_main form, then go to the form inside, then go to the ChildSettings object on that subform (which I assume is another subform), go to the form inside that subform, then finally to the UnitID.

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)

On Aug 5, 2015, at 8:37 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I am having an issue with passing a field called UnitID from a subform (frm_conveyance_list) which resides in the mainform (frm_main) to a popup form (frm_conveyance_create). the way the mainform is setup is as follows:

Forms!frm_main!Child1.Form!ChildSettings.SourceObject = "frm_unit_detail_w_tab"

I need to pass the Unit ID that resides on the frm_unit_detail_w_tab (called UnitID) to the frm_conveyance_create.

It use to get done simply like:

intArgs = Forms![frm_unit_detail_w_tab].UnitID

But in this scenario it does not work. I need to address a field on the SourceObject.

Any ideas?

Thank you,

Art lorenzini

Sioux Falls, SD

__._,_.___

---

Posted by: Art Lorenzini <dbalorenzini@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___