[AccessD] Question 2...returning to a form

Lots of ways around this John, but what I have is two buttons, one saying
preview and the other print. (actually some more as well,  email, PDF, List,
Labels, etc,  etc)


Once the preview comes up they can either click on file/print from the menu
or close and then click  on the  print button.

The  print button goes straight to the printer.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: 08 January 2010 18:54
To: Access Developers discussion and problem solving
Subject: [AccessD] Question 2...returning to a form

OK, for those of you that might have read my other post, this is the next
question...
 
For those of you that may not have read it...or maybe your attention span is
like mine and...where was I...oh, yeah...maybe you just need a reminder...
 
I've got an entry form, w/a button on it. Press the button and a voucher is
created from the data, and you get a print preview of said voucher. When you
close the preview, you are returned to the data entry form. But...and herein
lies the question...you are returned to record #1, and not where you were.
 
This isn't a huge problem, because in reality, you would almost always be
done w/a record, once you print and wouldn't need to return to it. But, the
whole reason it goes to a preview to begin with, is that you can check and
amend data. So, if there is a reason to change something, I don't want it
going to record one and need to travel back to the current record. 
 
An easy, although not perfect, approach to this, might be to just open the
form to the last record...contemplating this anyhow. Most of the time we
will be printing the last record anyhow, so this would probably get us by,
for the most part. 
 
However, if for no other reason, I'd like to do this, just so I can learn
how to do it. So, how can I have my calling form return to its last known
record?
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com