Displaying access records based on selection made in a combo box

[kennygee]

I am trying to learn VB after many years programming in Access. I am trying to do something in VB that is simple in Access. How do I display record data on a form based on the selection made in a combo box?

My problem may lie in not understanding which event is triggered when a new value is selected in the combo. I am working on the basis that when the new value is selected, I can then use the new value to reposition the data in the forms data control.

Sorry if this problem may be trivial.

Any help appreciated

Cheers

Kennygee

[shidec]

put code in ComboBox click event like this

Private Sub Combo1_Click()
 Data1.RecordSource = "select * from students where class_id='" & Combo1.Text &"'"
 Data1.Refresh 
End Sub
 

[kennygee]

shidec

Many thanks for your help. I am still getting used to the VB events. I had not realised that the event I needed was the Click event. In Access it would be the AfterUpdate event which I think is more descriptive.

All working now

Cheers

Ken