synchronize combo box

[gasx]

I have two synchronize combo box on a form I would like to select record from the first combo box the second combo box get first index record automatically is that possible and how I do that.

please help.

 

[jbehrne]

In the "after update" event of your first combobox you would run this code (Change variables to fit your db):

Dim strSQL As String
Dim strSQLSF As String

2ndComboboxName = Null

strSQL = "SELECT DISTINCT tblname.field FROM tblname "
strSQL = strSQL & " WHERE tblname.field = '" & 1stcomboboxname & "'"

2ndComboboxName.RowSource = strSQL

jbehrne

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations