Discussion Locked

Access 97 Stand Alone Form

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a form that takes info into then you hit a button that prints the current record into a report. I DO NOT want the records to save. How can I make a stand alone form, but still be printing to the current report?

3 replies

by jjjheimer

Why do you not want to save the record? You could build a temporary/alternative table solely for this report and save the data to it, this would save you the trouble of writing code. If you don't want to do that you could write an onClick event handler for your print button that copies the data fields to a bunch of global variables then executes the report. When the report loads you could simply read the values from the global vars. You could avoid assigning a data source to both form and report this way. Further still populate the form's data fields through a sql call on the form's open event making the data read-only from the database, but modifiable for the user. You could also tell the report where to get its data from through the global vars or directly through a specified table/query. Hope this helps and good luck,
John

by parier

Just take the data from a form and print it out on a report (Predesighed form) They are for passwords, thats why we don't want them to save. Thanks anyway.

This discussion is closed to new replies.