Quote Originally Posted by dataempress View Post
I'm not sure what the difference between record and recordset is. I actually thought they were synonyms and starting saying recordset because it sounded more technical. Could you please tell me the difference?
The difference between records and a recordset is the difference between how many records are physically stored in the database and how many records you ask to be retrieved from the database at any one given time via a database query.
Quote Originally Posted by dataempress View Post
How do you avoid loading all the records, because when a form and table opens, don't the records get loaded anyway?
That is probably true if you are using bound controls. Such controls should be avoided.

Use programming code in the form of SQL queries to get ONLY those records from the table that you need for any particular task at any particular point in time.