J
JG
I have a form with 5 combo boxes which combined represents the employeeID
and by using a parameter query im able to extract any data from the
employeeID. Now what i want to do is to do the same function and but
instead of typing a parameter i want to use the combo box and display the
data in a subform or subreport. Heres the schema to the very best of my
description.
cmb1 - e
- c
- f
cmb2 - CO
- JS
-AM
cmb3 - 000
- 001
- 002
cmb4 - XX
- PF
cmb5 - NO
- AA
an example employeeID would be cco000pfaa. now yesterday im able to query
this by just using the Like feature in criterea (exp: "Like "*" & [Enter
EmpID] & "*" ) and by typing CO and data would be extracted by employeeID
with the value CO and would output it on a datasheet. I would like to do
this same function using combo boxes and the output would display in my
subform/subreport in my form. I hope for people who read this can
understand what im talkin about. Any help would be great.
and by using a parameter query im able to extract any data from the
employeeID. Now what i want to do is to do the same function and but
instead of typing a parameter i want to use the combo box and display the
data in a subform or subreport. Heres the schema to the very best of my
description.
cmb1 - e
- c
- f
cmb2 - CO
- JS
-AM
cmb3 - 000
- 001
- 002
cmb4 - XX
- PF
cmb5 - NO
- AA
an example employeeID would be cco000pfaa. now yesterday im able to query
this by just using the Like feature in criterea (exp: "Like "*" & [Enter
EmpID] & "*" ) and by typing CO and data would be extracted by employeeID
with the value CO and would output it on a datasheet. I would like to do
this same function using combo boxes and the output would display in my
subform/subreport in my form. I hope for people who read this can
understand what im talkin about. Any help would be great.