Hi Richard, when you select a value from the Search Combo Box, why doesn t it filter the records in a way that completely removes all of the rest of the records (like a Query), to just give you all of the records you want? [You can still cycle through all of the records! with this combo box (using the navigation buttons) even those that don t have that value (bad!)]
Reply from Alex Hedley:
It applies a Filter. If you want the record set to change you'll have to use techniques taught in later classes that changes the source of the Form to a given SQL statement or base it on a Query that is passed a parameter from the Form.
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 8.