Unanswered: Adding Records To A Table Using VB Code
I have a table titled "Customers" and once a week they are required to "call-in" to the main office. I have created another table titled "CallInLog". I created a form that needs a command button to "Create" a blank log entry in table "CallInLog" for each Customer in table "Customers".
This new log entry has the Customer's Name, Date to Call by (7 days from beginning date) and a check box that the user can check as they call in. When checked, the final field will hold the "date called" and the date they called will be inserted there. I have completed the forms and the only question I have is how to create the records in table "CallInLog" for each entry in "Customers" when the "Create New Log Records" button is clicked by the operator.