Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Old 12-08-2018, 06:53 PM   #1
Newly Registered User
Join Date: Dec 2018
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Zrai is on a distinguished road
Subform showing only 1 record

Hi, I appreciate the help in advance. I'm new to Access, so I apologize if this is a basic question but it's something I couldn't figure out.

I have a form with a subform. It's a recipe database. The form contains all the relevent information for a recipe except ingredients.

i put ingredients into another table and display as a subform in datasheet view.

The issue arises when I input the ingredients, only the last item is displayed in the record. If I unlink the subform and main form, they show up, but the ingredients show on the next record of the main form.

I hope this makes sense. I want it so that when I input a record in the main form, and input ingredients into the sub form, the ingredients show up per record, and are blank when i go on to a new record.

Can anyone help?

Zrai is offline   Reply With Quote
Old 12-08-2018, 07:03 PM   #2
June7's Avatar
Join Date: Mar 2014
Location: The Great Land
Posts: 2,607
Thanks: 1
Thanked 624 Times in 617 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Subform showing only 1 record

Gotta be issues with PK/FK linking. If you want to provide db for analysis, follow instructions at bottom of my post.
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June7 is offline   Reply With Quote
Old 12-09-2018, 04:41 AM   #3
Newly Registered User
Join Date: May 2018
Location: USA baby
Posts: 2,037
Thanks: 39
Thanked 642 Times in 591 Posts
MajP has a spectacular aura about MajP has a spectacular aura about
Re: Subform showing only 1 record

In the properties of the subform control there are two properties

What are the values of these properties when you have them linked?
What is the primary key of the main form recordsource? (assume something like recipe ID)
What is the related key in the ingredient table? (assume something like ingredient id)
What is the view of the subform (single form, continous form, datasheet)?

MajP is offline   Reply With Quote

forms , subforms

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting record from subform and showing in mainform Andyconc Forms 3 07-28-2014 09:20 AM
Subform Only Showing Last Group Record lwallis Reports 4 02-26-2014 02:18 PM
Subform showing same record x times AndrewB Modules & VBA 6 07-24-2012 03:49 AM
Showing the most recent record in subform dbaldwin117 Modules & VBA 2 08-25-2011 06:34 AM
Showing single record from a subform rlowden Forms 4 08-30-2008 06:27 AM

All times are GMT -8. The time now is 06:04 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World