A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Subform Causes Main Form to show same record Multiple times



 
 
Thread Tools Display Modes
  #1  
Old March 27th, 2010, 07:36 PM posted to microsoft.public.access.gettingstarted
jassnaround
external usenet poster
 
Posts: 8
Default Subform Causes Main Form to show same record Multiple times

I have a form named PatientsInfo that is based on table Tbl_Patients. In
that form I have a subform that is based on table Tbl_FedPovertyLevel. I
have 2 fields from Tbl_FedPovertyLevel on the subform -- HouseholdMemberName,
HouseholdMemberIncome. When an additional HouseholdMember is entered into
the subform, it links to the Tbl_Patients correctly. But on the record
selector for the PatientsInfo main form, there are now several instances of
the same Patient based on how many HouseholdMembers I have entered into the
subform. I have to click the next record button several times until I see
the next Patient. I want only one instance of the PatientsInfo record to
show but with all of the HouseholdMembers showing. How can I fix this?
  #2  
Old March 27th, 2010, 09:21 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Subform Causes Main Form to show same record Multiple times

On Sat, 27 Mar 2010 11:36:01 -0700, jassnaround
wrote:

I have a form named PatientsInfo that is based on table Tbl_Patients. In
that form I have a subform that is based on table Tbl_FedPovertyLevel. I
have 2 fields from Tbl_FedPovertyLevel on the subform -- HouseholdMemberName,
HouseholdMemberIncome. When an additional HouseholdMember is entered into
the subform, it links to the Tbl_Patients correctly. But on the record
selector for the PatientsInfo main form, there are now several instances of
the same Patient based on how many HouseholdMembers I have entered into the
subform. I have to click the next record button several times until I see
the next Patient. I want only one instance of the PatientsInfo record to
show but with all of the HouseholdMembers showing. How can I fix this?


Doublecheck the Recordsource for the mainform. It certainly sounds like you
have the form based on a query joining Tbl_Patients and Tbl_FedPovertyLevel;
what you probably want is to have each form bound to its own table, or to a
query selecting and sorting records only from that table.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.