Populate cbo based on another cbp value

[hermie]

I saw this post in the newsgroup:
I have a combobox for "Departments" in Access 97 Form,
and another one for "Products". Since I have many
products in the dB, I don't want the user to scroll all
the way and look for the desired product. Instead when a
user selects a department, I want the "products" combobox
to display only the items related to that department.
Currently i'm storing departments in a single-column tbl,
while the products in another table, that also include a
department field that matches each product item. Any idea on how to
accomplish this?

I tried to do the same in my form but not get it work?
When I select the value in comobox 1 I see the values in combobox2 but can
not select any item from the list?

sql of the form query =
SELECT [students activo].Grupo, [nombre] & " " & [apellidop] & " " &
[apellidom] AS estudiante, [students activo].Nombre, [students
activo].ApellidoP, [students activo].ApellidoM, [tareas estudiantes].ss,
[tareas estudiantes].fecha, [tareas estudiantes].esptarea, [tareas
estudiantes].tarea, [tareas estudiantes].valor, [tareas estudiantes].puntos
FROM [students activo] INNER JOIN [tareas estudiantes] ON [students
activo].ss = [tareas estudiantes].ss
WHERE ((([nombre] & " " & [apellidop] & " " & [apellidom])=[Forms]![Form
tarea]![cbogrupo]));

row source of first cbobox = SELECT Grupos.Grupo FROM Grupos;
row source of second cbobox = SELECT [students activo].ss, [students
activo].estudiante, [students activo].Grupo FROM [students activo] WHERE
grupo=forms![form tarea]!cbogrupo;

Like to know why i cannot select a item from th elist in comobox2

Any help is welcome

Herman

 

[hermie]

Hi group
Problem solved after many tries and changes made
herman