Check out the Update Query. That should allow you to select and update multiple records. HTH!
Alienwebmaster --- In AccessDevelopers@yahoogroups.com, "Jerry Hull" <[EMAIL PROTECTED]> wrote: > > I need to assign notes to multiple records in a linked table. > > The tables and their pertinent fields: > > tblStudents > StudentID: Autonumber > Selected?: Yes/No > > tblStudentNotes > StudentNoteID: Autonumber > StudentID: Number, Long Integer > Date: Date/Time > TakenBy: Text, 25 Character > Note: Memo > > The tables are linked one to many on the StudentID Field. I need to be able > to assign the same note (Note field) to all the students for whom selected > is true. I'd like to be able to enter the values for TakenBy and Note just > once, and to have the Date field entered with Date(). > > I'd be happy with an append query that would do it - I'm just not able to > come up with that. I'd also be happy with some VB code that would do it. > > Thanks in advance for any help!!!! > > Jerry Hull > [EMAIL PROTECTED] > ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
