Save Textbox Value When Closing Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

panzerguy - 10 Jul 2007 23:42 GMT

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.

Reply to this Message

pietlinden@hotmail.com - 10 Jul 2007 23:52 GMT

> 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
[quoted text clipped - 8 lines]
> 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.

That's odd... why do you want to store calculated values? Usually not
recommended unless there's a very good reason for it. So what's
yours? Sounds like something you could achieve with a parameterized
totals query...

Reply to this Message

panzerguy - 11 Jul 2007 14:49 GMT

Actually, it's 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.

Reply to this Message

John W. Vinson - 12 Jul 2007 03:17 GMT

>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
[quoted text clipped - 8 lines]
>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.

Reports don't really have any usable events, and are not designed to capture
data (even such data as the current page being viewed). It's just *possible*
that the report's Close event could expose its Page property, but I rather
doubt it - you might want to ask on the Reports newsgroup.

If the user is just browsing data in a table or query and wants to note a test
no, might it not be simpler to use a Form (which has plenty of usable
interactive events) rather than a report?

John W. Vinson [MVP]

Reply to this Message