Does anybody know how to populate the values in a combo box depending on what value has been entered in another field?
For example, if you enter the name of department in a field and then went to another field where you could choose the staff names from a combo box, how would you limit it so it only looked at the staff from that particular department rather than the whole company?
I'm sure some IF..THEN statement can be carried out for this but not quite sure where and how.
For example, if you enter the name of department in a field and then went to another field where you could choose the staff names from a combo box, how would you limit it so it only looked at the staff from that particular department rather than the whole company?
I'm sure some IF..THEN statement can be carried out for this but not quite sure where and how.
