get Query From Button Pressing

Hello,
Trying to do the following
When I tyoe in some string in the textbox, and press search, it should show the filtered query results. It not refreshing when I am pressing the button. Please assist
Thank you
R
finalTestPlease.zip
RayneAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
<How did you set up the  subFrom “frmSource” – the steps >

select the table then Create Form > datasheet
save the form

the filtering is done by the codes in the click event of the button
0
 
RayneAuthor Commented:
check form1 Thank you
0
 
mbizupCommented:
It looks like the out put is correct to me - its showing ALL records that contain your search string in the ship name.

If you want to show DISTINCT results, change your query's SQL view to:

SELECT DISTINCT tblSource.[Ship Name]
FROM tblSource
WHERE (((tblSource.[Ship Name]) Like "*" & [Forms]![Form1]![myShipName] & "*"));

Open in new window


If that doesnt help, please let us know what is wrong with the output and what your expected results are.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
RayneAuthor Commented:
Hello,

Double click on Form1
Entered “Jones”
Clicked “Search” button
Results shows Everything!! All 66 records

I am not sure if that’s filtering correctly by “Jones”


If I enter in Jones, it should pull all the rows that has jones in that field
0
 
Rey Obrero (Capricorn1)Commented:
ttest this


open the form Form1 and type a value in the textbox, then click on the button
finalTestPlease.accdb
0
 
RayneAuthor Commented:
you need to zip it and attach...i am getting all wierd values in the browser when I open it
0
 
RayneAuthor Commented:
no need to zip, got it
0
 
Rey Obrero (Capricorn1)Commented:
better use this one
finalTestPleaseRev.accdb
0
 
RayneAuthor Commented:
This works Great, Can you explain me the steps, Capricorn. I am touching access after 5 years. Thank you
0
 
Rey Obrero (Capricorn1)Commented:
see the codes in the click event of the button.

what steps you want to know?
0
 
RayneAuthor Commented:
How did you set up the  subFrom “frmSource” – the steps
Thank you
0
 
RayneAuthor Commented:
how does the sbuform looks up values from the main form ? like setting the data
0
 
RayneAuthor Commented:
filtered data
0
 
RayneAuthor Commented:
I see this for it but not sure what means
showIt.png
0
 
RayneAuthor Commented:
Perfection to the Ultimate

Thanks Capricorn :)
0
 
RayneAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.