I posted this in the Access Forms forum but I thought I would post it here, too. This link will allow anyone wishing to answer to see what the thread there has covered:
thread702-519953
Here is my original post:
This seems like it should be a simple problem, but I can't get it to work. I have a table 'TrainRec' (training records) for my staff (over 70). Frequently we have 20 or more staff attending the same training. Rather than having to go in and enter the same data (name of training, date, hours, instructor) for every attendee, I would like to have a form based on an append query that would allow me to a) select all attending staff from a list box, and b) provide the training info c)hit an update to append the new training record info to all the selected staff.
I can't seem to get either of the first two functions to work. Is there an easier way? Am I misusing the append query? Any help is appreciated.
I'm using Access 2000.
Any help is appreciated!
thread702-519953
Here is my original post:
This seems like it should be a simple problem, but I can't get it to work. I have a table 'TrainRec' (training records) for my staff (over 70). Frequently we have 20 or more staff attending the same training. Rather than having to go in and enter the same data (name of training, date, hours, instructor) for every attendee, I would like to have a form based on an append query that would allow me to a) select all attending staff from a list box, and b) provide the training info c)hit an update to append the new training record info to all the selected staff.
I can't seem to get either of the first two functions to work. Is there an easier way? Am I misusing the append query? Any help is appreciated.
I'm using Access 2000.
Any help is appreciated!
