Query criteria from datasheet.

  • Thread starter Thread starter rob c
  • Start date Start date
R

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?
 
"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â€



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

I use this all the time.

rob c said:
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?
Click to expand...
Click to expand...
 
Back
Top