Make the RowSource for cbo2 and cbo3 the appropriate SQL and then in cbo1.Valid, do cbo2.Requery and cbo3.Requery and in cbo2.Valid do cbo3.Requery. HTH
>I need to use 3 comboboxes: cbo2 is dependent on cbo1 and cbo3 is dependant on cbo2.
>When tha choice has been made in cbo1 I need to have a SQL SElECT cbo2 to make the choices available and the same thing from cbo2 to cbo3.
>I would need to know how to do this.
>
>Thanks in advance
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.