code for SEARCH button

[Cindy]

Hi, could someone help me with the code to fix this SEARCH button please? When I type in the searchbox, the subform pulls up the data already. The button gives an error when clicked. I would get rid of the button but the searchbox looks better with it. Any help is appreciated.

 

[GinaWhipp]

Cindy, I already explained why it's not working in its present form in your last post. If you want to *make* it work did you try my suggestion of moving it to the Subform?

 

[vbaInet]

... in your last post.

--->
http://www.access-programmers.co.uk/forums/showthread.php?t=266927

 

[Cindy]

sorry didn't mean to be a nag. I'd checked yesterday's thread before starting this one and there wasn't an update at the time. Thanks again.

and you as well vbaInet!!

 

[GinaWhipp]

No problem, got a little tied up and I didn't have a chance before.

 

[Cindy]

Hey Gina, one more thing. In the On Click Event of the SEARCH button, it automatically takes me to an empty VB subroutine. At the beginning, when I clicked on the ellipses (...) it would show an option of macro or procedure. Now it goes straight to procedure. How can I switch the window from VB to macros?

 

[GinaWhipp]

That's new, it went straight to the Macro for me, did you change something?

 

[Cindy]

nah! I didn't.

 

[GinaWhipp]

Under File > Options > Object Designers uncheck *Always use Event Procedures*, close and reopen and it should be back to normal.

 

[Cindy]

it still took me strainght to :

Private Sub cmdSEARCH_Click()

End Sub

 

[GinaWhipp]

Delete those lines or it will always think you want to put something there.

 

[Cindy]

I did many times but whenever go back and I click on the ellipse (...). It recreates the lines:banghead:

 

[Cindy]

I clicked on the GOT FOCUS event and had a pop-up. It asked what I wanted: Macro, code builder, etc. That is what I need for the "ON CLICK" event but it doesn't pop up

 

[Cindy]

I selected "macro builder" for the double click event and went back to the On-Click event and the pop up came back. I'll apply the Filter. Hope it works. Many thanks Gina

 

[GinaWhipp]

Oh, I see you finally got it, let's hope it really does work!

 

[Cindy]

as you guessed, it didn't work! after typing the search text and clicking on the SEARCH button a dialogue box popped up showing:
[MacroError].[Description]

However when I finished typing in the searchbox and clicked the button, the find/replace box popped up. That is not what I want:banghead:

I want it to search the table based on the searchbox text.

 

[GinaWhipp]

Yeah, the only way I do that is via code because of the issue with Macros, to limiting. This one is my favorite...
http://allenbrowne.com/ser-62.html

 

[Cindy]

Thanks Gina. That's a lot of code to grasp at once and my head hurts I'll move on to something else for now

 

[GinaWhipp]

When you're ready we're to help! Side note: While it looks like a lot it's really not that bad.