Richard, on 4/22/12 I sent my discussion question briefly here, and a longer email with the code, thinking that was better. The longer email (direct to you) has not yet been connected to this, so I will paste it here and hope that works:
Richard, I am stuck in the mud! No matter how many times I have gone over Lesson 3 of SQL2Seminar I cannot get my VendorPriceUpdateF to alter by my choice of the category. I have the tables and queries you created – and they look identical to yours. The zoom SQL for the list box price list (@ 7:45) also looks the same as yours:
SELECT [ProductVendorNewPricingQ].[ProductID], [ProductVendorNewPricingQ].[ProductCode], [ProductVendorNewPricingQ].[ProductName], [ProductVendorNewPricingQ].[UnitPrice], [ProductVendorNewPricingQ].[Category], [ProductVendorNewPricingQ].[LastUpdated], [ProductVendorNewPricingQ].[NewPrice] FROM ProductVendorNewPricingQ ORDER BY [ProductName];
I think I am doing the VBA correctly and it also looks like yours (at 10:18):

Private Sub CategoryCombo_AfterUpdate()

    ProductList.RowSource = "SELECT ProductID, ProductCode, ProductName, " & _
        "UnitPrice, Category, LastUpdated, NewPrice FROM ProductVendorNewPricingQ " &
        "WHERE Category = " & CategoryCombo & " " & _
        "ORDER BY ProductName;"

End Sub

But I am not sure how to save the VBA after I put this in, other than Ctr-S. Maybe I am doing something wrong at this point. When I try to change the category in the categorycombo (at 10:48), eg looking at only keyboards I get an error message: “error accessing file. Network connection may have been lost.”

I have started over at least 6-8 times, have found typos or other coding mistakes and corrected them, but I can no longer see what could be wrong. Does this info help? Can you pull me out of the mud?

Thanks so much!
Bonnie