Link to home
Start Free TrialLog in
Avatar of Michael Dean
Michael DeanFlag for United States of America

asked on

Link Subform to Mainform Combobox

I have a parent form which contains a Combo Box with the following SQL:

SELECT Mid(Claimant,InStr(1,Claimant," ")+1) AS Expr1, Strings.Claimant
FROM Strings
WHERE ((([Claimant] & "")<>""))
GROUP BY Mid(Claimant,InStr(1,Claimant," ")+1), Strings.Claimant
ORDER BY Mid(Claimant,InStr(1,Claimant," ")+1);


I want to link a Subform to the answer that the person chooses in the combo.
The Subform Contains Claimant, so I am trying to figure out how to link claimant.
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

set the master/child link fields property of the subformcontrol

but, i think it is not a good thing using a part of the claimant field as the bound column of the combo box, as it is very possible to have duplicate values.

do you have a unique id field for claimants?
it will be best to use the unique id as the bound column of the combo box.
Avatar of Michael Dean

ASKER

I want each record that contains the name Claimant to show in the subform, so its good if there are duplicate values.

I am not sure what the values should be in the subformcontrol however.

Master:  Combo171 ?  How do I pick the correct column being returned in the combo box?
The Bound Column property of the comboBox determines the column being returned.  In your case, setting it to 1 will return Expr1 and setting it to 2 will return Claimant.
User generated image
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial