Google Answers Logo
View Question
 
Q: MS Access request from a subform within a form... ( Answered,   1 Comment )
Question  
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
Answer  
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/
Comments  
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

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy