{SOLVED} Help with query output

Originally Posted by LoneStar

Hello...

I have the following query which gets input from user entered information. When this is executed the results is displayed in a dynaset. What I am trying to figure out is if there is a way to display the results on the same form or a msgbox. Please let me know if you can help.
Thanks..Lonestar

SELECT KenanCrmTable.ComponentIOSC, KenanCrmTable.ComponentDesc, KenanCrmTable.MemberType, KenanCrmTable.PackageType, IOSCfeatureNameTable.RelatedFeatures, IOSCfeatureNameTable.AAISdescription
FROM KenanCrmTable INNER JOIN IOSCfeatureNameTable ON KenanCrmTable.ComponentIOSC=IOSCfeatureNameTable.I OSC
WHERE (((KenanCrmTable.ComponentIOSC) Like forms!frmSearchTable!IoscNum.value));

Originally Posted by pks00

Well if u create a form based on this query

SELECT KenanCrmTable.ComponentIOSC, KenanCrmTable.ComponentDesc, KenanCrmTable.MemberType, KenanCrmTable.PackageType, IOSCfeatureNameTable.RelatedFeatures, IOSCfeatureNameTable.AAISdescription
FROM KenanCrmTable INNER JOIN IOSCfeatureNameTable ON KenanCrmTable.ComponentIOSC=IOSCfeatureNameTable.I OSC


And u have a textbox where the user enters IoscNum, u can perform a filter or a find