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 --------------------~-->
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/.QUssC/izNLAA/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/
