repost b/c no response

[rjkimme]

I have an add button that adds the newly input data into the table from the form. What I want to do now is when you click the button you get a verify form that lists the info in report form that was put in and a verify to make sure all the info is correct. If not, then hit no and return back to the original form. If verify, then add to the table and return to an empty form. Also, I have a clear button which erases the form but currently it also closes the form. Not good at VB so simplistic help appreciated.

 

[Carol]

I would suggest the following:

On the add button, make sure that it is an add button only, and does not include a command to go to a new record, that way, the current record information is still available.

Next within the same coding, add a DoCmd to open a Preview Form in Pop-Up displaying the results of the entered information.

Or if you want to have a preview report, then set the report to view in preview mode and have the active form minimize at the same time.

Have a close button on the form or make sure that a toolbar is available with a close button for the report in preview mode.

This way, the current record is still available for editing and if any changes are required, they would just have to click on a Save button that would save the edited information.