In Lesson 1 I have copied DiscountRate from CustomerF to OrderF with default value =[Forms]![CustomerF]![DiscountRate] and the discount rate reflects on a new record on OrderF.
However, when I copy DiscountRate to OrderDetailsF with =[Forms]![OrderF]![DiscountRate] DiscountRate will not reflect the discount on a new record , still 0.0%. I deleted the field, compacted/repaired closed and reopened, and still no luck.
Any suggestions before I drop back to another copy?
Thanks - Mike M
Michael MunitzOP
@Reply 3 years ago
Michael MunitzOP
@Reply 3 years ago
Please stand down - I figured it out. In OrderDetailT Design View I had DiscountRate as Integer. I changed it to reflect DiscountRate in OrderT which is Double, and now DiscountRate in OrderDetailF reflects properly what is in OrderF. Thanks.
Mike M
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 9.
