Search results

[Update] I moved the code to before the INSERT INTO clause in the cmdAddRecords procedure and now it works perfectly. :rolleyes: I am using an unbound form because it has a multi-column text box that I only need to retrieve one field from.

Thanks for your quick response, but that doesn't work either. It still appends the table with whatever info it does have, and there are no message boxes. I'm not sure if it a coding problem. Could I possibly have something set wrong?

I've got my form working, and all of the record updating is working fine, so now I am working on error trapping. I need to check if any of the two textboxes are empty, or nothing has been selected from the combobox. I am using the BeforeUpdate method. I am not getting any syntax errors. I am...

Thanks, dude, that's exactly what I was looking for! :D

WooHoo! You guys rock! :D I still need to add some error trapping, and some message boxes, but I'm sure I can figure that out on my own. (If not, I know where to come for help). :)

I'm trying to grasp what is going on here, but my SQL knowledge is pretty flaky. The SQL statement says: INSERT INTO the table [SOPTraining] in the following fields, (EmployeeNumber, SOPNumber, RevisionNumber, TrainingDate) the following VALUES (the selected values from lstEmployees, the value...

I have designed a database to store training records. I created a form with a multi-column text box so I can select all employees who have attended a training session that day, and update all records at once. The form has a combo box, as well as two text boxes. Even though the listbox has...