Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
querying two combo boxex
0 views
Skip to first unread message
vrhari
Apr 18, 2003, 8:43:01 PM4/18/03
to
I m using an access project, connected to SQL 2000 server.
i have a form with two combo boxes. i want to query the
2nd combo box based on the value i select in 1st combo
box. how to go about it. kindly help..
thank
i have a form with two combo boxes. i want to query the
2nd combo box based on the value i select in 1st combo
box. how to go about it. kindly help..
thank
Perry
Apr 19, 2003, 2:05:35 PM4/19/03
to
Assuming
- both on same form
- Bound column of yr first combo returns ID field value
- both on same form
- Bound column of yr first combo returns ID field value
Private Sub ComboOne_AfterUpdate()
Dim sSQL as string
sSQL = "SELECT * FROM TblWithValues WHERE MyIDField = " Me.ComboOne
ComboTwo.RowSource = sSQL
End Sub
Krgrds,
Perry
"vrhari" <vrh...@winvision.net> schreef in bericht
news:02d501c3060c$a17fd730$a101...@phx.gbl...
0 new messages