Hi Richard, I have 2 quick questions about this lesson: 1)Wouldn't it just be faster to build the CustomerListF off of the CustomerT (vs. the CustomerSortedQ we build here first)? Are there some advantages to this new method? 2)When I try to open the CustomerListF, it asks for a Parameter Value for "CustomerT.DiscountRate" - even though that field isn't in the CustomerSortedQ it's based on. I already set RecordSource= CustomerSortedQ already. Any ideas? Thanks a lot for all your help! You're a very good professor. :)
Reply from Alex Hedley:
Well CustomerSortedQ will be sorted whereas the Table won't, it probably has a concatenated Field of Name which the Table won't. Is DiscountRate on the Form anywhere?
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 Beginner 7.