Subform Refresh

[acnovice]

Hi,

Subform refresh problem. I have a main form with data sheet sub-form. There is a SPN combo box in sub-form to bring up part number if it is registered. If the part number is not registered yet, open part number registration form. My problem is after register a new part number, it doesn't show up from my SPN combo box in sub-form.
There is a query to bring up registered SPN from table.

I put refresh command button in main form but it doesn't refresh sub form.

frmSIsummary1 --> Main form
sfrmSIsummary1 --> sub form

Private Sub cmdRequerySISortbyQ_Click()
Me.sfrmSIsummary1.Requery
End Sub

Thank you for your help.

 

[gharabed]

That's funny. This is the exact same problem I am having. I'm curious to see the answer.

 

[scking]

One way that verifies the main form is open first.

If FormIsOpen("frmPprEditDev") Then
Dim f As New Form
Set f = Forms("frmPprEditDev")
f.sfrmPprUsage.Requery
End If

OR

Forms("frmPprEditDev").sfrmPprCompLinks.Requery

Forms("frmSIsummary1").sfrmSIsummary1.Requery

OR

Use the bang operator but I generally don't so I'm unsure of the syntax.



---------------------
scking@arinc.com
---------------------