|
|
Subject:
MS Access request from a subform within a form...
Category: Computers Asked by: jbarrancos-ga List Price: $4.50 |
Posted:
24 Aug 2005 09:43 PDT
Expires: 23 Sep 2005 09:43 PDT Question ID: 559785 |
I am a very new user of MS Access. There is my problem: I have a form (F_InputEquipment) within a form (MF_Equipment). From F_InputEquipment run a query with the following Criteria: [forms]![F_InputEquipment].[txb_InputServer] and every time I have an input request of that field. What is the syntax to do a field reference from a subform within a form..? I will rerally appreciate your help. Thanks & Regards Jose Barrancos jbjet@yahoo.com |
|
Subject:
Re: MS Access request from a subform within a form...
Answered By: hammer-ga on 24 Aug 2005 11:07 PDT |
jbarrancos-ga , The Access Web FAQ contains a complete reference for referring to one form and its controls and properties from another form. The page below shows both references that start from the Main form and also references starting from the subform. Refer to Form and Subform properties and controls http://www.mvps.org/access/forms/frm0031.htm - Hammer Search Strategy ---------------- None. I use this excellent FAQ often and have it bookmarked. Additional Information ------------------------ Access Web http://www.mvps.org/access/ |
|
Subject:
Re: MS Access request from a subform within a form...
From: stolis-ga on 24 Aug 2005 10:55 PDT |
I think your looking for something like: [Forms]![MF_Equipment].Form![F_InputEquipment].[txb_InputServer] You need to refer to the parent form first, then the child as part of the "Form" collection within that. -Stolis |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |