>Now here is the problem when I try and click the button to open the
>report it asks me if i want the data saved but i don't and if I dont
>my report will not show up. But if i do it will save it then show the
>data but ruining my table. So is it possible to show this data on a
>report without saving it.
It's possible, but not easy. Typically a Report is based on a query displaying
data in a Table (put there via a Form, usually). A Form isn't really a very
good data repository - I'm not sure that printing out the contents of an
unsaved form record will get you all that much ! You'll need to leave the Form
open to the record; you can look at the data on the form just as easily as on
a sheet of paper.
But... if you really want to waste paper... you can create an unbound Report
(don't base it on ANY table), and put controls on it with control sources
=Forms!YourFormName!Controlname
to display the contents of the currently-open record on the form. Do this for
all the controls that you want to see. Print the report from a command button
on the form (the command button wizard will do this for you).
John W. Vinson [MVP]
guitarfunk24@yahoo.com - 15 Jun 2007 19:37 GMT
On Jun 12, 7:54 pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> >Now here is the problem when I try and click the button to open the
> >reportit asks me if i want the data saved but i don't and if I dont
[quoted text clipped - 19 lines]
>
> John W. Vinson [MVP]
Well thank you for the help on the report problem I am still working
on it but just so you know it is for a cost analysis for a company so
we can sell ideas and how much they cost and make a neat sheet so you
can report you information. If we where to save it because we did
want that idea then we could save it. But I don't want to save
something we may never use. If you have anymore help on it it would
be most helpful because I did replace my report with the formula above
but the form still asks me if I want it saved and if I click no it
deletes what I typed.