I have a products form where my control source for MSRP is as follows.
=IIf(IsNull([MSRPUSD]),[MSRPCDD],([MSRPUSD]*Forms![Conversion Rate]!FieldValue))
This works great and gives me exactly what I want, mathematically, except for the fact that the Conversion Rate form has to be open. Is there anyway that I can get the MSRP field on my Products Form to do the above without having to have the Conversion Rate Form open? Any help would be greatly appreciated.
Thx in advance.
Tina
=IIf(IsNull([MSRPUSD]),[MSRPCDD],([MSRPUSD]*Forms![Conversion Rate]!FieldValue))
This works great and gives me exactly what I want, mathematically, except for the fact that the Conversion Rate form has to be open. Is there anyway that I can get the MSRP field on my Products Form to do the above without having to have the Conversion Rate Form open? Any help would be greatly appreciated.
Thx in advance.
Tina