Edit, Reports, Saving Forms/Reports with Multiple SubForms

[natwong]

Hi All,

I'm hoping that someone could help me out since I'm new with Access.

Background:
Database was set up as a simple data entry and reporting tool for Program Initiatives. The data entry page has main form with 9 sections (1 main section and 8 subsections). These subsections are all employed using subforms. These are all joined through the ProgramID. The Report is set up in a similar fashion with main and subreports too.

Unfortunately I ran into a couple issues.and had questions about resolving them:

* How can I save the records after everything is entered instead of as I enter them in the data entry view?
Currently, the data needs to be entered sequentially to work correctly. Is there a way to prevent the records from saving until I am done entering in all the information?

* How can I edit previously entered data in the form view?
Currently, the data entry view only allows new additions; cannot edit previously entered data.

* How can I make the report searchable?
Report is not searchable because it is based on query (for the main section) and multiple SubReports (for the subsections). I have queries that make it main and subform fields searchable by returning the ProgramID, but I am having trouble tying these returned results to the Report through the ProgramID.

Thanks so much,
Nate

[nico5038]

* How can I save the records after everything is entered instead of as I enter them in the data entry view?
Only by using temporary tables for the subforms.

* How can I edit previously entered data in the form view?
Check the form's properties, make sure that the Dataentry property is set to "No".
(Under the Data tab)

* How can I make the report searchable?
You don't search a report, that's done on the form's. You can add a new combobox on the mainform and select the third option (search record) to search by the ID, or use the right-click popup menu to filter on one or more fields.

Nic;o)