how do I get a subform to link to a main form

[kretzsc]

I have the following query on my main form i am using a combo box to try to link to my subform. The subform shows the first records data but when I select another value from the drop down the subform doesn't update. It's like they aren't really linked.

Query from main form
SELECT DISTINCT Left([BUS_KEY],InStr([BUS_KEY],'-')-1) AS policy_id


FROM IIWSCREF_IIW_BUS_KEY_XREF
WHERE (((IIWSCREF_IIW_BUS_KEY_XREF.IIW_TRGT_TBL_NM)="FIN _PROV"));
Query from subform
SELECT IIWSC_FIN_PROV_DETAIL.FIN_PROV_DETAIL_ID, IIWSC_FIN_PROV_DETAIL.FIN_PROV_ID, IIWSC_FIN_PROV_DETAIL.POPULATION_INFO_ID, IIWSC_IIW_TYPE.TYPE_DESCRIPTION, IIWSC_FIN_PROV_DETAIL.EFFECTIVE_FROM_DATE, IIWSC_FIN_PROV_DETAIL.EFFECTIVE_TO_DATE, IIWSC_FIN_PROV_DETAIL.ORIGINAL_EFFECTIVE_TO_DATE, IIWSC_FIN_PROV_DETAIL.VALID_FROM_DATE, IIWSC_FIN_PROV_DETAIL.VALID_TO_DATE, IIWSC_FIN_PROV_DETAIL.OOS_REVERT_IND, IIWSC_FIN_PROV_DETAIL.ADDED_REQUEST_ID, IIWSC_FIN_PROV_DETAIL.DETAIL_KIND, IIWSC_FIN_PROV_DETAIL.DETAIL_TYPE, IIWSC_FIN_PROV_DETAIL.DETAIL_SUBTYPE, IIWSC_FIN_PROV_DETAIL.DETAIL_AMOUNT, IIWSC_FIN_PROV_DETAIL.EXTERNAL_REFERENCE_DS, IIWSC_FIN_PROV_DETAIL.DETAIL_DESCRIPTOR, Left([EXTERNAL_REFERENCE_DS],InStr([EXTERNAL_REFERENCE_DS],'-')-1) AS Expr1, IIWSC_FIN_PROV_DETAIL.CURRENT_RECORD_FL
FROM IIWSC_IIW_TYPE INNER JOIN IIWSC_FIN_PROV_DETAIL ON IIWSC_IIW_TYPE.TYPE_ID = IIWSC_FIN_PROV_DETAIL.TYPE_ID
ORDER BY IIWSC_FIN_PROV_DETAIL.EXTERNAL_REFERENCE_DS;


I am liking policyid to Expr1

[Bob Fitz]

Have you set the "Link Child Fields" and the "Link Master Fields" properties of the subform?

[kretzsc]

Yes. I set both of those properties. It works great if I link the uneditied field - BUS_KEY AND EXTERNAL_REFERENCE_DS. It appears the problem is when I try to use the string functions and then use those modified fields in the link master and child fields. Is there a problem with using a modified field vs. a straight field from the table?

[Bob Fitz]

Hi

You could try to requery the subform in the AfterUpdate event of the combo box.