Save Textbox Value When Closing Report

[panzerguy]

I have textboxes on a report that are filled using a query (Access
2000). The report has many records, and the records on the report
are
sorted by a textbox, txtTestNo. The user sorts through the records
using the navigation buttons at the bottom of the report. When the
user finds the record needed, they close the report.

Is there a way I can save the txtTestNo value for the record the user
was on when they closed the report? Let's say there are 10 records
representing Test No's 1 - 10 (the txtTestNo text box is formatted as
an integer). The user navigates to Test No 8, and they close the
report, which takes them back to a "Main Menu" form. I need to save
the Test No for that record, in this case the number 8.

The textbox is not a calculated value. The value is stored in a
field
in a table. When the user exits the report, he'll have the option to
edit that record he was looking at when he exited. Since there are
several records in the report, I need to know which record needs
editing. To do that, I need the Test No. from that record.

 

[Carl Rapson]

I have textboxes on a report that are filled using a query (Access
2000). The report has many records, and the records on the report
are
sorted by a textbox, txtTestNo. The user sorts through the records
using the navigation buttons at the bottom of the report. When the
user finds the record needed, they close the report.

Is there a way I can save the txtTestNo value for the record the user
was on when they closed the report? Let's say there are 10 records
representing Test No's 1 - 10 (the txtTestNo text box is formatted as
an integer). The user navigates to Test No 8, and they close the
report, which takes them back to a "Main Menu" form. I need to save
the Test No for that record, in this case the number 8.

The textbox is not a calculated value. The value is stored in a
field
in a table. When the user exits the report, he'll have the option to
edit that record he was looking at when he exited. Since there are
several records in the report, I need to know which record needs
editing. To do that, I need the Test No. from that record.

I don't think you can do that from a report, because Access reports aren't
interactive. Are you sure you couldn't set up a form to look something like
the report and have the user scroll through the records that way? It would
be easy to get the value from a form.

Carl Rapson