Intelligent Access VBA command buttons and the Clone of a recordset
and Form navigation.
- Movies project GUI with command button names
while Current Record is 1st record, and RecordCount is greater than 1.
Printer Width version
- 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
- 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
- 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
- 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
- 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
- Bookmark technique illustrated:
Saving a bookmark in a String variable and using it later to return
to a favorite record.
Printer Width version