• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 582
  • Last Modified:

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
0
BSAS_ITGuy
Asked:
BSAS_ITGuy
  • 5
  • 5
2 Solutions
 
coffeeshopCommented:
Just change the "DefaultView" property of your subform to "endless from"
0
 
BSAS_ITGuyAuthor Commented:
Thanks that was so simple , will they be able to use this same view when adding a new record. Will it allow them to create new lines down the list or is that only the viewing mode.
0
 
coffeeshopCommented:
You're right. New records can be added at the end of the list, if the property "Allow additions" is set to "True", this is by default.

Everything works same in both modes, so you can decide whats better for your UI. But you cannot use a "Endless Form" within an "Endless Form". If you need such a construction, you can set both forms view to "Datasheet".
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
BSAS_ITGuyAuthor Commented:
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.
0
 
coffeeshopCommented:
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.
0
 
BSAS_ITGuyAuthor Commented:
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.
0
 
coffeeshopCommented:
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.
0
 
BSAS_ITGuyAuthor Commented:
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
0
 
coffeeshopCommented:
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.
0
 
BSAS_ITGuyAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now