General discussion

Locked

Access 97 Stand Alone Form

By parier ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 Stand Alone Form

by jjjheimer In reply to Access 97 Stand Alone For ...

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

Collapse -

Access 97 Stand Alone Form

by parier In reply to Access 97 Stand Alone For ...

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.

Collapse -

Access 97 Stand Alone Form

by parier In reply to Access 97 Stand Alone For ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums