Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Referancing a subforms control

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Apples76 - 02 Jul 2007 13:00 GMT
i have a value i would like to assign to a subforms control but i am having
no luck in doing so.

the main form is called "Site_info_frm"
the subform is called "FAsub_info_frm"
and the control is called "File_path"

could someone show me how to put them together to insert the value.

Thanks
Daniel - 02 Jul 2007 13:38 GMT
The basic synthax is:

Forms![MAinFromName]![SubFormName].Form.[ControlName]

so in your case you could do something like:

Forms![Site_info_frm]![FAsub_info_frm].Form.[File_Path]="NewValue"
Signature

Hope this helps,

Daniel P

> i have a value i would like to assign to a subforms control but i am having
> no luck in doing so.
[quoted text clipped - 6 lines]
>
> Thanks
Douglas J. Steele - 02 Jul 2007 13:41 GMT
Forms!Site_info_frm!FAsub_info_frm.Form!File_path

Note, though, that depending on how you added FAsub_info_frm as a subform on
Site_info_frm, it's possible that the subform control on Site_info_frm might
be named something other than FAsub_info_frm. If the subform control on
Site_info_frm is named something other that FAsub_info_frm, us the name of
the subform control instead.

You might find it useful to read
http://www.mvps.org/access/forms/frm0031.htm at "The Access Web"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>i have a value i would like to assign to a subforms control but i am having
> no luck in doing so.
[quoted text clipped - 6 lines]
>
> Thanks
Roger Carlson - 02 Jul 2007 14:13 GMT
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates how to handle a lot
of reference issues on subforms and sub-subforms.

Signature

--Roger Carlson
 MS Access MVP
 Access Database Samples: www.rogersaccesslibrary.com
 Want answers to your Access questions in your Email?
 Free subscription:
 http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

>i have a value i would like to assign to a subforms control but i am having
> no luck in doing so.
[quoted text clipped - 6 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.