after event combo boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks to all those who answered the numerous queries about cascading combo
boxes.

I was able to set up three boxes in my form where the input in the preceding
box selects the values available in the next.

I used the requery code suggested by Mr. Vinson:

Private Sub cboColumn1_After Update()
Me! cboColumn2.requery
End Sub

However when I reopen my form it dosn't show the values from the previous
entries into each field. I have to select and click the preceding combo box
and then the value appears.

How do I get previous entries in the combo boxes to show by default when the
form is reopened?

Does it involve the reply by Sprinks:

Me!MyControl.DefaultValue = Me!MyControl

instead of the requery code?

Thanks for your patience and help.
 
You can add the requery code also to the OnCurrent event of the form, that
will refresh the combo row source when you open the form, and when you'll
move between records
 
Back
Top