The scenario : I have a Subform1 set within a 'Main' Form. Within Subform1, I have a control (Field1_PK) and a Subform2. On Subform2, I have a combo that takes its data from a lookup Query. Within the Query, I want to be able to limit the records to ones that have a value set to that of the current Field1_PK value in Subform1.
In the Query, I have set the Criteria for Field1_FK (present in Subform2) to the following :
[Forms]![Main]![Subform1].[Form]![Field1_PK]
And that - in itself - seems to be working. The problem comes when, in Subform1, I navigate (simply using the built-in navigation button) to another record. The lookup doesn't update accordingly. Do I need to be creating some VBA code in the On Current Event, in order to force the lookup to update ?
TIA
In the Query, I have set the Criteria for Field1_FK (present in Subform2) to the following :
[Forms]![Main]![Subform1].[Form]![Field1_PK]
And that - in itself - seems to be working. The problem comes when, in Subform1, I navigate (simply using the built-in navigation button) to another record. The lookup doesn't update accordingly. Do I need to be creating some VBA code in the On Current Event, in order to force the lookup to update ?
TIA