[newbe]

I am creating a database to track the courses an employee takes for the company. This will also be used for creating the registration list for a class being offered. I have created the following tables: Accounts (name of business locations),...

I am creating a database to track the courses an employee takes for the company. This will also be used for creating the registration list for a class being offered.

I have created the following tables: Accounts (name of business locations), Courses (name and course number of classes offered), Course schedule (dates of specific classes), employees (name, Account, etc of each employee), and registered students (the student id & schedule id). I believe my table set up removes redundancy, so I think I am OK up to here.

I am trying to create a form that will allow me to select an employee and based upon that populate the account field with the appropriate account name. If the employee moves to another account, then the account must be changed and the account id stored back in the Employee table.

I need to have the movement to a specific record done by selection of the name, not by entering a record number (or unique id).

I have tried forms and sub forms; I have tried macros using the SetValue expression, but I can't seem to get everything I need. Often I recieve a message stating that "The object doesnt contain the Automation object 'Test table 1'." It also says to "Check the components's documentation for information on the properties and methods it makes available for Automation operations." I have no idea what this is trying to tell me.

Any help you can provide will be greatly appreciated. Right now I am stumped