G
Guest
I have a query that is run off of a combo box. The combo box has project
numbers in it. For example 12345 for project A and 11111 for Project B. I
have a table that has project numbers and then project and task numbers such
as 12345.11 or 11111.123. What i want is for the user to be able to select
from the combo box the project number ( 12345 or 11111) and then the query
runs and shows information for records that are both for the selected project
and the selected project with the subtask. For instance if the user selected
12345, the records I would want to show up in the query are 12345 and
12345.11
Is there anyway to do this. I tried the "like" function and it worked when
my "like" function was manually entered in the criteria (such as:
like"12345*") that worked but I dont know how to combind that equation with a
combo box. Any help would be greatly appreciated. TIA!
numbers in it. For example 12345 for project A and 11111 for Project B. I
have a table that has project numbers and then project and task numbers such
as 12345.11 or 11111.123. What i want is for the user to be able to select
from the combo box the project number ( 12345 or 11111) and then the query
runs and shows information for records that are both for the selected project
and the selected project with the subtask. For instance if the user selected
12345, the records I would want to show up in the query are 12345 and
12345.11
Is there anyway to do this. I tried the "like" function and it worked when
my "like" function was manually entered in the criteria (such as:
like"12345*") that worked but I dont know how to combind that equation with a
combo box. Any help would be greatly appreciated. TIA!