M
Minikoop
I have a form which gives the user the ability to pull data up from one
of two combo boxes, both pull the data perfectly. My problem is I
would like the other combo box to display the matching value of the
project pulled from the other combo box. For example: combo box 1
lists project codes and combo box 2 & 3 (linked to pull a record)
contain the PM and the project name. If a user selects the project
code to pull the record the PM (combo 2) and the project name (combo 3)
doesn't match the project displayed. Same problem exists the other
way, if a user selects the PM and project name to pull the record the
project code (combo 1) doesn't match the project displayed.
of two combo boxes, both pull the data perfectly. My problem is I
would like the other combo box to display the matching value of the
project pulled from the other combo box. For example: combo box 1
lists project codes and combo box 2 & 3 (linked to pull a record)
contain the PM and the project name. If a user selects the project
code to pull the record the PM (combo 2) and the project name (combo 3)
doesn't match the project displayed. Same problem exists the other
way, if a user selects the PM and project name to pull the record the
project code (combo 1) doesn't match the project displayed.