By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,233 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Edit, Reports, Saving Forms/Reports with Multiple SubForms

P: 3
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
Feb 23 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
* 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)
Feb 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.