{SOLVED} Help with query output

[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));

[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

 
e.g.
 
me.filter = "ComponentIOSC = " & Me.UserEnteredField
me.filteron = true
 
or
 
dim rs as dao.recordset
 
set rs=me.recordsetclone
rs.findfirst "ComponentIOSC = " & Me.UserEnteredField
if rs.nomatch=false then
    me.bookmark=rs.bookmark
endif
 

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));

[LoneStar]

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

 
e.g.
 
me.filter = "ComponentIOSC = " & Me.UserEnteredField
me.filteron = true
 
or
 
dim rs as dao.recordset
 
set rs=me.recordsetclone
rs.findfirst "ComponentIOSC = " & Me.UserEnteredField
if rs.nomatch=false then
    me.bookmark=rs.bookmark
endif
 

I got it to work....well sort of...it keeps on giving me a data type mismatch error! Any sugguestions.....

[pks00]

If ComponentIOSC is a string field then u need to wrap it with single quotes

eg

rs.findfirst "ComponentIOSC = '" & Me.UserEnteredField & "'"

[LoneStar]

Thanks! that worked..