assassin4213
Registered User.
- Local time
- Today, 18:51
- Joined
- Feb 16, 2004
- Messages
- 16
Hello Everyone,
I have a form with a drop down menu for selecting a unique vendor from a list. A query is tied to this drop down menu so that once there is a vendor selected - only this vendor and their specs are provided by the query.
I would like to take the spec values in the query and place them in text fields on a form that has lab data. Then we can visually see if this sample is within the specs provided to the vendor.
Would someone be able to help me with the code. I've been trying the following code with success on the first line just to set the text field to a value.
[Form_Fuel2001].txtVCSpec = 3
However, when I try the next line, it does not work.
[Form_Fuel2001].txtVCSpec = [query.Vendor Spec Query Sort for Fuel Entry.intVol].Value
Any help would be greatly appreciated.
Thanks,
Greg
I have a form with a drop down menu for selecting a unique vendor from a list. A query is tied to this drop down menu so that once there is a vendor selected - only this vendor and their specs are provided by the query.
I would like to take the spec values in the query and place them in text fields on a form that has lab data. Then we can visually see if this sample is within the specs provided to the vendor.
Would someone be able to help me with the code. I've been trying the following code with success on the first line just to set the text field to a value.
[Form_Fuel2001].txtVCSpec = 3
However, when I try the next line, it does not work.
[Form_Fuel2001].txtVCSpec = [query.Vendor Spec Query Sort for Fuel Entry.intVol].Value
Any help would be greatly appreciated. Thanks,
Greg
