Query criteria from datasheet.

[rob c]

I set up a subform with the Default View set to datasheet. I need to set up
a combox box on the subform/datasheet which is based on information in an
earlier field n the datasheet for the same record. I saw a posting which
shows the statement to use, but it didn't work and I am now unable to find
that posting. The statement that I used is:

[Forms]![ViewProCustMgr]![ProjectTechResource subform].[form]![Prod]

Can anyone provide me with some guidance on how to make this work?

 

[rum23]

Check this out...http://www.mvps.org/access/forms/frm0031.htm

I use this all the time.

 

[rob c]

"I just check out the link, thank you for the information.
I'm stilling having a problem.


Me!Projects.Form![ViewProCusMg subform].Form.Product


Main form is: "ViewProCusMgr;
Subform to “ViewProCusMgr is: “Projectsâ€
Subform to “Projects†is “ProjectTechResource subformâ€
The name of the field to be referenced is “Productâ€

Check this out...http://www.mvps.org/access/forms/frm0031.htm

I use this all the time.

I set up a subform with the Default View set to datasheet. I need to set up
a combox box on the subform/datasheet which is based on information in an
earlier field n the datasheet for the same record. I saw a posting which
shows the statement to use, but it didn't work and I am now unable to find
that posting. The statement that I used is:

[Forms]![ViewProCustMgr]![ProjectTechResource subform].[form]![Prod]

Can anyone provide me with some guidance on how to make this work?