I would like to know everyone’s suggestion for looping through a recordset when you have multiple values you are watching. Here is my example.

Recordset of (LastName, FirstName, Address, State)

Smith Joe 111 Main Street GA
Smith Jim 222 South Street GA
Jones John 333 West Street FL
Jones Sue 333 West Street FL
Jones Bobby 333 West Street FL
Wall Harry 123 First Street FL
Wall Marry 123 First Street FL

Now here is what I would like to do. I want to write the whole recordset to a listbox, but, I want the list to Break on Last Name and I also want to Break if they live at different addresses. This means I need to know when the Last name field changes, as well as when (if) the address changes within the same Last Name. I have seen this done many ways, however, I am interested in the most efficient way of doing it.

Thanks