Sorry the they are combo boxs, is it possible that you tell me step by step
how to do this.

"Klatuu" wrote:

Use the Lost Focus event of the first list box to requery the second list
box. For the second list box to change, its row source will need to be
filtered on the content of the first list box.

The trick here is whether the list boxes are multi select or not. If they
are not multi select, I would suggest using Combo boxes instead. The are
easier to work with and are easier for the user. If they are multi select,
then creating the filtering becomes a bit more code intensive.

"Professional_in_need_of help" wrote:

I have to list box strLoggedBy and str Group and I want the group box to
change everytime I change the strLoggedBy box. Here the setup of thier tables

strLoggedby is coming from tblLoggedByNames the strLoggedbyNames column.
strGroups is coming from tblLoggedByNames the strGroup column.

Please help.