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?
 
John TsioumprisConnect With a Mentor Software & Systems EngineerCommented:
Take a look at my attachment at first
Learn---Copy.accdb
1
 
John TsioumprisConnect With a Mentor Software & 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 FyeConnect With a Mentor Commented:
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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
 
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
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.