Access 2003 Subform List View
I have an access form that I have created a mainform/Subform view. I have linked the forms on the one to many relationship. I need help with setting up the view of the subform to show all the details in a list that go with the main record.My curennt report works as such :
Main Order# 2456
Item Item Price
#1 Hose 2.00
1 of 10 records
I have to scroll my mouse to see record 2,3,4, etc showing only one at a time.
I would like it to show the details in a list as such:
Main Order# 2456
Item Item Price
#1 Hose 2.00
#2 Line 5.00
#3 Jar 12.00
#4 Hose 8.00
* of 4 records
See attach picture.
Access-list.png
Main Order# 2456
Item Item Price
#1 Hose 2.00
1 of 10 records
I have to scroll my mouse to see record 2,3,4, etc showing only one at a time.
I would like it to show the details in a list as such:
Main Order# 2456
Item Item Price
#1 Hose 2.00
#2 Line 5.00
#3 Jar 12.00
#4 Hose 8.00
* of 4 records
See attach picture.
Access-list.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I can add a new record to the main report , but I can't get to the subreport to start adding the lines. Can the subreport data be added through this view.
Yes. If you have linked the main form with the subform, this should work without problem. After saving the main record there should be a new line in the subform for adding detail records. If not, check the relations between master and detail table and the link from the subform to the main form. As stated above, "Allow additions" must be true and the datasource must be editable.
ASKER
I don't know what could be wrong . I have checked and allow additons, deletions, allow edits and data entry is set to yes on the Main and Subreports. I have type in data on the main report but the subreport only shows the field headings
I have noticed something that on the Main report when I click the > next record button it gives me a new record to start entering data and adds to the record number. On the subform the next record button grays out on the last line or record.
I have noticed something that on the Main report when I click the > next record button it gives me a new record to start entering data and adds to the record number. On the subform the next record button grays out on the last line or record.
For saving the master record, try to click on the recordmarker, if it is enabled (in your picture it is), so you stay on the same record. Or just go back to the saved record if you changed to a new one. A requery to the subform should done automatically after saving, if everything is OK. Does it worked before you switched to endless form? Your picture seems to me as everything is correct.
"Data Entry" is by default false. You should set it only to true if you want to hide data that always exist.
"Data Entry" is by default false. You should set it only to true if you want to hide data that always exist.
ASKER
I stll cannot get the details section to open for editing. I have test the main report does write to the table but details form is locked somehow. Here is a screen shot.
Edit-Details.png
Edit-Details.png
If it worked before switching to the endless form something changed: Check that the key fields from your detail to your master form linked correct. Check that the datasource on your detail is editable. "allow additons" and "allow edits" must be true for master and detail. Avoid errors in the master form (like in your picture). Check the relations between the master and detail table.
ASKER
Thanks for all your Help. I have gotten it to work. It was something in the connection with the table from the form showing like the form was not updateable from the table. I put a new row in the table and it never showed up on the from list.
What I did was used the form wizard to connect to the table and went through all the steps. Then I let it automatically setup and save the form. I then went back in and lined every thing up the way I wanted it. Now I have my add record button for the subreport.
I was searching on here and found a lot of posts unresolved for this issue. Could someone please let admin know that this was my solution. Most of the other posts titles were add record greyed out.
details-good.png
What I did was used the form wizard to connect to the table and went through all the steps. Then I let it automatically setup and save the form. I then went back in and lined every thing up the way I wanted it. Now I have my add record button for the subreport.
I was searching on here and found a lot of posts unresolved for this issue. Could someone please let admin know that this was my solution. Most of the other posts titles were add record greyed out.
details-good.png
ASKER