Popluating Combo box from another combo box selection

[lrw0831]

I have a table named AssignedTo. In this table are the fields: AssignedTo_ID, Department, Employee.

On my form, I need to create 2 combo boxes. The first one will select the department. Based one what department is selected, the second combo box will be populated with employees in that department.

Can someone help me on how to do this?

[saratee]

I am also need solution to the same problem!!!! mine is however a list( two lists rather)

[NeoPa]

Saratee,

This is not your thread, so please don't hijack it. Feel free to read it and get any info from it that is helpful. However, if YOU have a question, please post it in a separate thread.

Administrator.

@Irw0831, I think we can manage this. Give me a while for a little thought.

[NeoPa]

Right, the first step is to have a read through Example Filtering on a Form.

It may well be that this is all you need. Certainly all the points are covered (although the example isn't exactly your scenario).

If, after reading this, you need more help, just let us know.