Hello Alex. Thanks for your time. To answer your question directly: No, the RecordSource of the FORM (QuickSearchF) is the Customer table (CustomerT). At least it is now - because in order to try to keep going in the seminar, I went back 2-3 lessons and rebuilt the QuickSearchF from scratch.
The second time I arrived at 21:38 in this lesson without that problem. QuickSearchF seems to work fine now. So I must have done something the second time that I didn't do the first time.
Interesting note: I encountered a similar "parameter request" after creating ProductSearchF in lesson 26. The form we built in lesson 26 was built on top of a previous form we created. So I saved the entire code, then rebuilt ProductSearchF from scratch as well - then pasted the code into it. The "parameter request" went away. It would seem there is a step that I am continually missing. But it works out the second time. Thanks again for your time.
Reply from Alex Hedley:
That Field needs to exist in the RecordSource for you to be able to sort by it.
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 Search Seminar.
