I made the CustomerListF and it gives me a parameter error for the discount rate. The discount rate is not in the query. I've had this error before and I think I added the Discount Rate and just made it not showable.
Kevin Robertson
@Reply 2 years ago
Are you saying you unchecked the Show Check Box for DiscountRate?
If there is no criteria or no sort the field will be removed from the Query.
Showing the field shouldn't affect the functionality of the Query.
If the field is needed in your List Box it must be in the Table or Query stated in the Row Source.
Mandy DuncanOP
@Reply 2 years ago
I fixed it. There was some criteria in the sort field in the form. I don't know where that came from.
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.
