Close report and edit information on report

J

jped

I have a function in my database where a user can search for a previous order
they completed (report) and view it. I would like to be able to have the
user close the report and be prompted if they would like to edit it or not.
If they select yes, then bring up the form where they enter data. The form
where they enter data is based on a purchase order number that is
automatically generated. All the information that is needed for reports is
stored in tables. Is there a ways to close the report and have it bring up
the form where they can edit the data? Please help!

Thanks!
 
A

Allen Browne

You could use the Close event procedure of the report to OpenForm to the
editing form, using the WhereCondition to load just the one record.

In my experience, it's much easier to work the other way around, i.e. show
the record to the user in the form. They can then edit it there if needed,
or print the report if that's what they want to do. Forms are much more
flexible for the on-screen searches.
 
J

jped

I agree, and after I made the post, I played around and decided to show the
previous orders in the form view, then print to a report after they make the
edits. Thank you for your reply!
 
Top