• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 571
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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