Auto fill memo box

[alip43]

I have created a database for school reports. A form opens with records of students based on an underlying query. At the bottom of the form are memo fields (Attendance, Targets, etc). I would like to be able to type something into one of these memo boxes and the same information to appear in the memo fields of the rest of the filtered records
PS VB is not my best subject!

 

[randy700]

Using the same criteria you used to create the underlying query that displays the records, create another query and make it an "Update" query. On the "Update to" line type....
forms!YourFormName!YourControlName

Place a command button on the form with code to run the update query. After all fields have been filled in, click the button.

You're calling them memo fields but, unless you expect to put large amounts of information in here, I would suggest using text fields instead. Text fields can hold up to 255 characters.

 

[alip43]

Sorry to be ungrateful but as these reports will be printed and sent out to pupils I didn't really want any buttons appearing on the form. Is there any way of doing this so that when they have typed a comment into one of the boxes and moved onto the next record the information in the memo box will be, in effect, copied and pasted onto the memo box of the next record

 

[randy700]

Forms are designed for data input, not for printing. Reports are normally printed. If you use a button on the form to assist with the data input process, it will not appear on the printed report.