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
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 3.