Sub Form question

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

I have a code that I have in my Combo box [cbOwnerID_AfterUpdate()]that
shows filtered records in my Sub Form, Is it possible to use this code so as
when I scroll through my form it will update my Sub Form
...............Thanks for ant assistance ...Bob
If nRtnValue = vbYes Then
cbOwnerID1.value = cbOwnerID.value
Form("SubPaymentShowChild").Form.Filter = "[OwnerID]=" & Me.cbOwnerID
Form("SubPaymentShowChild").Form.FilterOn = True
Form("SubPayModePayChild").Form.Filter = "[OwnerID]=" & Me.cbOwnerID
Form("SubPayModePayChild").Form.FilterOn = True
If Len(Me.cbOwnerID.value & "") > 0 Then
Me.cbOwnerID.Locked = True
Dim rsFullAmtPaid As ADODB.Recordset
Set rsFullAmtPaid = New ADODB.Recordset
 
are you sure you need to use code for this? try adding OwnerID to the
LinkChildFields property of the subform control (within the mainform), and
add cbOwnerID to the LinkMasterFields property of same.

hth
 
Back
Top