create a report from a form that is not updated yet

[Guest]

I have a form that users input data. I want the user to be able to view a
report before updating the data to the table. Is this possible?

 

[Guest]

Hi Shari

Not really - well yes (maybe)??

If you update data into a bound control on a form this "will" be saved into
the table the form is based on as soon as the data is entered and control if
left/or some other event criteria is met.

You could enter data into a number of unbound controls - view a report - if
the data/report is OK use a simple OnClick event (or something else) to
update the data in the unbound controls into the tables. But this is not as
simple as it may seem and is full of possible problems.

I would go for some form of validation to make sure the data is correct
before the table/form will accecpt the data - much easier this way.

 

[Guest]

Thank Wayne, but I am using unbound controls for the users to input. The
only validation I can do is to make sure the data is numeric. I have the code
to move the unbound control data to my table, however my concern is the end
user fat fingering in an amount and I would like them to view a report before
pressing the update control.

Thank you for all your help.