COMBO BOX SYNCRONIZING

  • Thread starter Thread starter FFC
  • Start date Start date
F

FFC

I NEED TO SYNCRONIZE TWO COMBO BOXES
THE FIRST BOX WOULD DISPLAY A LIST OF TABLES
THE SECOUND BOX WOULD DISPLAY THE MANUFACTURES IN THAT
TABLE AND THERE RELATED INFORMATION
NOTE: ALL FIELD NAMES THAT I NEED IN THE SECOUND BOX ARE
THE SAME.
 
Hi:

In the Combo "OnEnter" event you could requery the RowSource for the Combo
like this (Here NewID is your Combo and TableCombo is the Combo with Table
names)

Private Sub NewID_Enter()

If Me.TableCombo.Text = "" then
Exit sub
end if

Me.NewID.RowSource = "Select [Manufacturer] from [" & Me.TableCombo & "]"
Me.NewID.Requery

End Sub

Regards,

Naresh Nichani
Microsoft Access MVP
 
Hi:

In the Combo "OnEnter" event you could requery the RowSource for the Combo
like this (Here NewID is your Combo and TableCombo is the Combo with Table
names)

Private Sub NewID_Enter()

If Me.TableCombo.Text = "" then
Exit sub
end if

Me.NewID.RowSource = "Select [Manufacturer] from [" & Me.TableCombo & "]"
Me.NewID.Requery

End Sub

Regards,

Naresh Nichani
Microsoft Access MVP
 
Back
Top