Changing table data using a Report

[Leathem]

I have a report which lists the names of students enrolled in a class based on a query which finds them in a table listing all classes. However I'd like to be able to put an entry box next to the name on the report which allows me to change a datum (for example, GRADE) in the original table. I've tried numerous macros and expressions that should run upon entering the data in the box and pressing Return using the Property Sheet/Event menu, but everything I've tried returns some error message or other. How can I do this?

 

[DCrake]

Reports are for reading, they are not designed to be data capture devices you need to do what you want via a form.

 

[Leathem]

I originally tried a form, but haven't been able to get it to show a complete list of the students with an entry box next to each on. The best I can do is a combo box that pulls up one student at a time.

 

[pikoy]

I originally tried a form, but haven't been able to get it to show a complete list of the students with an entry box next to each on. The best I can do is a combo box that pulls up one student at a time.

I would use a list box rather than a combo box. And Yes, Report is only output not entry. Use a form to pull a report.