Multiple record update

[rube]

Is there a way to add multiple records at one time. Say you have a parent table called Students containing 10 students, w/ the Primary Key StudentID. There is a child table, tblActivity that contains activities for the students. The students are divided in half, groups A and B. Say you want to update the Activities to show group A took the SAT without touching the five records one at a time and adding an activity via the subform subActivity/tblActivity. Is there a way to add these 5 records for Group A all at once with an unbound Activity Update form, where I could just input the Date and Activity and hit a button to update these?

Thanks for any input,

rube

 

[Mike375]

Is there a way to add multiple records at one time. Say you have a parent table called Students containing 10 students, w/ the Primary Key StudentID. There is a child table, tblActivity that contains activities for the students. The students are divided in half, groups A and B. Say you want to update the Activities to show group A took the SAT without touching the five records one at a time and adding an activity via the subform subActivity/tblActivity. Is there a way to add these 5 records for Group A all at once with an unbound Activity Update form, where I could just input the Date and Activity and hit a button to update these?

Thanks for any input,

rube

Are you familiar with the macro actions SetValue, GoToRecord, OpenForm and RunMacro

Mike

 

[Rich]

Forget the silly Macro idea, use a multiselect list box to add the records selected into your table

 

[rube]

Explanation?

Rich,
Thanks for the reply. Would you mind elaborating a little?

What do I bind the frmActivityInput to? And will this automatically update the PK (StudentID), as well as the StudentActivityID for the activity?

On the form where I input the activities, I just need to select the StudentID so I know who the activities are for, input a Date and Activity.

I appreciate your time.

 

[Mile-O]

Rough example attached....

 

[rube]

Mile-O-Phile

Thanks so much, you are the Bomb! I appreciate the detailed explanation. I also want to tell you thanks on a label post you gave a while ago. I use raised images and labels for all my commands in lieu of command buttons now to give it that "web" based effect.

Thanks again,

Rube

 

[mbertuol]

Not working to update same table

Thank you for the nice DB example. I have modified in order to suit my needs. I need a particular field to be updated simultanously. However when I click the "update" button, only the first record of the list is updated, regardless which of them are selected.

Also, the query is NOT updated after the Update command.

Any help is trully appreciated.