I have set up a system that allows a user to enter MS Access through Forms (Switchboard). Then the user can select to begin filling in their tax return, which is made up of several forms (Step 1 allows the user to go into Q1 & Q5, then continue on to Step 3 which then allows the user to select which forms to display in the next window consisting of Personal Details and Q10 AND/OR Q11)
this is the file:
The 4 problems are:
1. When a user fills in the first form Step 1 by selecting relevant questions, he can then open up the relevant form. The forms need to be linked through usercode within relationships so that when they load up, they can be closed/reloaded and finally at the end, exported into a report.
When some forms are opened and then closed, they do not keep the data if reopened (Step 3, when you click on continue, does not save the details, and say an error message).
2. How can I implement that Q1 (employment in Step 1) will allow the user to create several Employers, that are all linked to the one record in Step 1?
3. I have set up a form within a form (at the bottom of the PDF) that allows the user to add records, delete records etc, while on the right there is a subform (in Table View). How do I allow the user to click on the records in the table to bring up the relevant record in the main form?
4. How do I create an output of all the data onto a sheet once the user finishes?
For the table programmer_mode, I have managed to set it so it creates a report with the headings and records, but at the top it places the headings as just the field names, without showing the actual data.
I don’t know how to create a report with all the fields from all the tables – Personal Details Q1, Q2, Q10, Q11.
this is the file:
The 4 problems are:
1. When a user fills in the first form Step 1 by selecting relevant questions, he can then open up the relevant form. The forms need to be linked through usercode within relationships so that when they load up, they can be closed/reloaded and finally at the end, exported into a report.
When some forms are opened and then closed, they do not keep the data if reopened (Step 3, when you click on continue, does not save the details, and say an error message).
2. How can I implement that Q1 (employment in Step 1) will allow the user to create several Employers, that are all linked to the one record in Step 1?
3. I have set up a form within a form (at the bottom of the PDF) that allows the user to add records, delete records etc, while on the right there is a subform (in Table View). How do I allow the user to click on the records in the table to bring up the relevant record in the main form?
4. How do I create an output of all the data onto a sheet once the user finishes?
For the table programmer_mode, I have managed to set it so it creates a report with the headings and records, but at the top it places the headings as just the field names, without showing the actual data.
I don’t know how to create a report with all the fields from all the tables – Personal Details Q1, Q2, Q10, Q11.
