Edit Forms with Master/Multiple SubForms
I'm hoping that someone could help me out since I'm new with Access.
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,