We will begin by learning how to open a Recordset with an SQL statement.

You will learn how to load a list of customers into a Listbox using your Recordset.

You'll learn how to generate a list of active states based on which states appear in your customer table. This way you don't have to see a list of all 50 states if you have no customers from most of them.

You'll learn how to modify the records in your Recordset. In this case, we'll make a button that you can click once and it will increment the number of seminars that each customer has attended.

You will learn how to work with Multi-Select List Boxes so you can pick one or more specific records in a listbox to work with.

You'll learn how to add new records to your table and listbox using the recordset.

You'll learn how to delete the selected records.

Finally, you'll learn how to use db.Execute to run an SQL statement.

Access 321 - Course Outline

1. Customer ListBox, Part 1
Open Recordset with SQL
SQL WHERE Statement
Adding Items to a ListBox
AddItem
Row Source Type: Value List
Access 2000 Users: No AddItem

2. Customer ListBox, Part 2
Add the ID
Column Widths
Clearing Your List Box
ListCount
RemoveItem
Combo of Unique States

3. Edit Records
Editing One Record
rs.Edit
rs.Update
Editing Multiple Records
Loop Through And Edit

4. Multi-Select List Boxes
Simple v. Extended
Loop Through Items With ListCount
.ItemData(x)
.Column(1,Row)
.Selected Property
For Each
Object Collections

5. Adding & Deleting Records
Adding a Record
AddNew
Sorting Our Customer List
Deleting Records
rs.Delete
Always Have an Are You Sure? Prompt

6. Execute
db.Execute
INSERT INTO SQL Command