Form creation where I can duplicate data from one field to the next

  • Thread starter Thread starter Timothyt F. Taylor
  • Start date Start date
T

Timothyt F. Taylor

I need to be able to have the content of a memo field in
one record be able to automatically populate the same field
in other records. I then need to be able to print this
field in a report. I work for a school system and the
teachers want to be able to enter a class comment on a
report card form that will automatically appear on every
student's record. Then they want to be able to print them
out. Is this possible?

Thanks,

Tim
 
Timothyt F. Taylor said:
I need to be able to have the content of a memo field in
one record be able to automatically populate the same field
in other records. I then need to be able to print this
field in a report. I work for a school system and the
teachers want to be able to enter a class comment on a
report card form that will automatically appear on every
student's record. Then they want to be able to print them
out. Is this possible?

Thanks,
Click to expand...

If this is part of a permanent record you will have to do an update query.
If not this is one of the few places where *not* having a relationship is a
good thing.
Simply add a table with one record (the message) to the query the reports
are based on.
Do not join the table and you get a Cartesian set. The product of all
records in Table A and Table B.
In this case the field will just appear once for all records.

Dlookup on the reports will also work and you could maintain a record of all
the comments using the date or something as the criteria for the comment.
 
Back
Top