Intelligent Access VBA command buttons and the Clone of a recordset and Form navigation.

  1. Movies project GUI with command button names while Current Record is 1st record, and RecordCount is greater than 1.
    Printer Width version

  2. Movies project Form at DESIGN time showing the invisible Image controls and the invisible film field. The "film" field is only visible when User is adding a new record, because the Combo Box shows movie name otherwise.
    Printer Width version

  3. Movies project Form_Current event procedure code, part #1. Displaying the proper Category Image. Declaring the RecordSet Object variable to point to the Clone.
    Printer Width version

  4. Movies project Set recClone = Me.RecordsetClone and the code to handle the Adding of a New record, when the recordset is not empty. In other words, adding a 2nd or 3rd or nth record, where n is GREATER THAN 1.
    Printer Width version

  5. Movies Form intelligent command buttons code for the most general case is shown here in the Else clause. Notice how the recClone object is utilized.
    Printer Width version

  6. Clone method explained in context of BookStore type of example where new records must be created from some of the existing records. Bookmark property is also illustrated.
    Printer Width version

  7. Bookmark technique illustrated: Saving a bookmark in a String variable and using it later to return to a favorite record.
    Printer Width version