I want to give you a bit more information following my last comment regarding the button not displaying the correct record.  I tried re-doing the whole database with the same result.  I then tried redoing the tutorials again but starting in the database you had created.  The button worked!  I decided it must be a setting in access that you have set but not informed us of on your video.  Or perhaps your version of access and access 2007 have different defaults.  Either way I diagnosed the problem and when I create a button in access 2007 and look at the 'on click' properties it displays [embedded macro].  This button does not filter the CustomerF form correctly.  When I view your button it displays [event procedure].  I tried opening this up which took me to Visual Basic.  I had no idea what I was doing but I copied the code and changed my button to [event procedure] then pasted the code into visual basic, changed the names to correspond with my names and hey presto it worked!  However, I don't want to have to repeat this process each time so can you please offer me any help on this?

Many thanks