Are Standalone Forms Possible?

[MSealy]

Is it possible to have a form that only holds the data on the screen to send to a report without having to store data in a table?
And would it also be possible to then have a command button which clears this data for another go?

Any ideas?
Cheers.

 

[dawnd3]

Yes. You can create a form and not attach it to a record source. When you click on "new" to create a new form, do not select a table or query. Then you can lay down unbound controls (text boxes, etc) and have the report you are running read the data off of those controls. I believe the field in the report would have to just refer to the Form and the control on the form. Does this help? Dawn

 

[MSealy]

Thanks. It worked!
It's a shame Access isn't very user friendly in this department. I had to remember to refer to the name of the Unbound box rather than the name used in the label beside it. And then use

=Forms![MyFormName]![TextBoxName]

on the Unbound report textbox.

Sorted