Subform just wont refresh when i update comboform

  • Thread starter Thread starter nokie
  • Start date Start date
N

nokie

Hai I been struggling to get my subform updated but it
just won't update from the comboform. whenever I close and
save it and reopen again then the subform will reflect the
correct data. I link the child and master link correctly.

Pls help guys.... I
 
Not sure what a comboform is? Can you give us specific information about
your form and what you're doing on it? I'm guessing that you're using a
combo box on the main form to select a value and then you want the subform
to be synchronized to that value?
 
Yeah Ken you read my mind right. I had just designed a
call centre assignment form. When I choose a customer name
from "customer detail"'s table in the combo box then that
specific customer detail such as address, phone no, e-mail
will appear in the subform. However the data in subform
just won't change not untill i close and reopen the whole
form...headache...I'm rushing my final year project. Help
Ken or anybody.. Thanks
 
Put code on the AfterUpdate event of the combo box to requery the subform:

Private Sub cboBoxName_AfterUpdate()
Me.SubformControlName.Requery
End Sub
 
Hey Ken thanks it works...Yahoo
-----Original Message-----
Put code on the AfterUpdate event of the combo box to requery the subform:

Private Sub cboBoxName_AfterUpdate()
Me.SubformControlName.Requery
End Sub

--

Ken Snell
<MS ACCESS MVP>




.
Click to expand...
 
Back
Top