opening a second form from main/subform

[PJPCVP]

Hello, I have a problem that I cannot figure out. 3 months ago I knew nothing about Access. Now I am building databases and learning everything about access that I can for work.

I have a main form (ConsumerFrm) with a sub-form (IncidentFrm). I have established a one - many relationship with ConsumerID to ConsumerID from both tables. One consumer can have many incidents.

Now, I have an "open form" button on my main form that will create a referral (ReferralFrm). I have fields from ConsumerFrm and fields from IncidentFrm that populates into the ReferralFrm. A one- many relationship has been established from ConsumerID to ConsumerID in the ReferralFrm.

The current record from my main form populates into the ReferralFrm but the data from my subform does not. I keep getting the first incident record only and not the current incident record. As I said, one consumer can have more than one incident and the same consumer can have more than one Referral.

Can someone please help figure out why only the first associated incident record keeps showing up with the current consumer record on my Referral form? I want the current consumer record and the current incident record to show up on the new referral form.

Example:



ConsumerID #1 and IncidentID #2 -------------> ReferralID #1

however, the following shows up instead..

ConsumerID #1 and IncidentID #1---------------> ReferralID #1

I hope I made this simple to understand. Thank you for your time.

Pjp

[RuralGuy]

How are you selecting the "Current Incident" record in the SubForm?