SEARCH RESULT IN POP WINDOW or POP UP DATASHEET VIEW FORM

Hi,

Wonder I can get search result from a query in a TABLE in pop up WINDOW mode or DatasSheetForm. Please review attached file, it will open in search form When you enter names ROGER or last name SMITH it will give me result in table, but i want in FORM or some kind of POP window.

Thanks
Learn.accdb
Roger GillManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
The attachment is missing.....and the Experts here have a notorious inability in crystal ball...we are all working hard to fix it but it takes time......just kidding...attach the file man to take a look
but i will take a guess and i would say that probably you need:
docmd.OpenForm "TheFormThatWillHaveTheResult",,,,,acDialog

Open in new window

1
Dale FyeOwner, Developing Solutions LLCCommented:
I do this quite frequently for search forms.

I put the search criteria at the top of the form and add a subform to the bottom of the form to display the results of the search.  Then the user can select the appropriate record from the subform and click the GoTo button (or simply double-click the record selector in the subform).  This is especially helpful when searching on birth date, which so many systems concerned with client confidentiality are using as the primary search field for people.
1
Roger GillManagerAuthor Commented:
Sorry Guys, Mr. John the way you guys solving the problems, seems like you guys do have the crystal ball , lol

Thanks
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

John TsioumprisSoftware & Systems EngineerCommented:
Take a look at my attachment at first
Learn---Copy.accdb
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Roger GillManagerAuthor Commented:
Thanks alot God Bless You alll !!!
0
Roger GillManagerAuthor Commented:
Thanks alot Mr John God Bless you all  !!
0
John TsioumprisSoftware & Systems EngineerCommented:
glad i helped you
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.