Wayne
I tried suggesting what you said but it stll comes up as a msg text box
not a msg combo box heres is the sql the was genrated when i used to
wizard to set up the query
SELECT tblDetail.Det_ID, tblCategory.Cat_Code, tblName.Plant_Name,
tblName.Generic_Name, tblContainer.Cont_Size, tblDetail.Cost,
tblDetail.Price, tblDetail.Quantity, tblLocation.Loc_Code
FROM tblName INNER JOIN (tblLocation INNER JOIN (tblContainer INNER JOIN
(tblCategory INNER JOIN tblDetail ON tblCategory.Cat_ID =
tblDetail.Cat_ID) ON tblContainer.Cont_ID = tblDetail.Cont_ID) ON
tblLocation.Loc_ID = tblDetail.Loc_ID) ON tblName.Plant_ID =
tblDetail.Plant_ID
GROUP BY tblDetail.Det_ID, tblCategory.Cat_Code, tblName.Plant_Name,
tblName.Generic_Name, tblContainer.Cont_Size, tblDetail.Cost,
tblDetail.Price, tblDetail.Quantity, tblLocation.Loc_Code
HAVING (((tblName.Plant_Name) Like "*" & [Enter the plant name or frist
characters of the name:] & "*"));
Yr assitance appreciated
Wayne Morgan wrote:
Place it in the criteria field instead of what you have. Access will probably put brackets
around each part when you are done. The form must be open (visible or hidden is ok) for
this to work.
Remember the value of a combo box is the value of the Bound Column for the row that is
selected. If the value you are looking for is in a different column, you will need to
specify the column.