Ask a new question

Microsoft Access, Search engine in forms not finding anything.

I have a database, and out of nowhere the "search engine" on the forms is not working as intended, so I have to manually find everything.

I would type in various names of clubs and it would find them for me, and now it doesn't.

I have a form for athletes, and a form for clubs, and neither work

|

With "search engine", do you mean you click on a control, and hit Ctrl+F for the Find dialog?

-Tom.
Microsoft Access MVP
Phoenix, AZ

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

You need to provide further details. What does "not working" mean? How does your search work? What, exactly, are youu doing to try and search?

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I tried to attach a screenshot on my post but it wouldn't let me.

I attached it here

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hello, I attached a screenshot on this reply because it wouldn't let me on the post.

Basically on this search function, I would look up a club's name. This data was pulled from a table, for example my form is frm_clubs and the table is tbl_clubs (I am not 100% sure as I am not the creator of this database). We have had this problem before and it was easily solvable, but I don't remember how to make Access link the form to the table again.

What I mean by not working, is when I type a club's name now, it doesn't pull up any searches, and I have to manually find the club with the arrows in the right of the search field

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 19, 2024 Views 20 Applies to: