L
Luna Saisho
Hiya,
I had posted this about a week ago and got an answer that unfortunately
didn't help out. Since then, I had another project to work on, and have gone
back to this to find I'm still stumped.
Basically, it goes like this:
I have "Form-Main" with two subforms: "Form-Main_Locations" and
"Form-Main_Shipment".
In the shipment area is a field called RecvDate. What this field should be
filled with, is the date we receive the product. When you click into this
field (I have it set to OnEnter so they can enter needed info and when they
get to here, it's set) it comes up with an error.
What I want it to do in "Form-Main_Shipment" is to have it look at
[ShipType] to find out if it's OTR or Rail (OTR means over the road, or by
truck) most likely with an iif statement. I want it to pull the value from
the Locations subform, which contains the days it takes to ship from that
location in the fields [OTR] and [Rail]. Back in the shipment subform,
[RecvDate] should have the result of [ShipDate] plus either [OTR] or [Rail]
as appropriate.
If this doesn't make sense, please let me know.
Thank you in advance for any assistance!
Stephanie
I had posted this about a week ago and got an answer that unfortunately
didn't help out. Since then, I had another project to work on, and have gone
back to this to find I'm still stumped.
Basically, it goes like this:
I have "Form-Main" with two subforms: "Form-Main_Locations" and
"Form-Main_Shipment".
In the shipment area is a field called RecvDate. What this field should be
filled with, is the date we receive the product. When you click into this
field (I have it set to OnEnter so they can enter needed info and when they
get to here, it's set) it comes up with an error.
What I want it to do in "Form-Main_Shipment" is to have it look at
[ShipType] to find out if it's OTR or Rail (OTR means over the road, or by
truck) most likely with an iif statement. I want it to pull the value from
the Locations subform, which contains the days it takes to ship from that
location in the fields [OTR] and [Rail]. Back in the shipment subform,
[RecvDate] should have the result of [ShipDate] plus either [OTR] or [Rail]
as appropriate.
If this doesn't make sense, please let me know.
Thank you in advance for any assistance!
Stephanie