In this video I’ve added a combobox in which I’ve hardcoded A, B, C, D, F, etc I run through the code showing you how the combo-box after update event passes its value through to a function. The function is designed to manipulate the SQL String to to create essentially a variable SQL Statement an SQL Statement which will contain A or B or C or D — depending on the selection you making the combo box. I explain the problem with hard coding the data in the combobox row source as a value list. There’s another problem to be aware of. Your code may not return all of your records, especially if the record contains a non-standard character. I demonstrate how you can use the query builder Grid along with the expression Builder to build a sophisticated query to extract the first letter of the field from the table. The query returns all of the records in other words lots of duplicates. The duplicates can be eliminated by adding the group by clause to the query. I hope you can see here the goal is to write code which needs no modification in the future. If you had stuck with a list of values in the combobox, then anytime a user entered a non-standard character, you would have had to to modify the combo box to take this non-standard character into account.