UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Search Form Using Query, Access 2016    
 
   
brastedhouse
post Sep 20 2019, 10:59 PM
Post#1



Posts: 102
Joined: 16-March 15
From: Chautauqua, NY


Hello again, I have a form that is bound to a query. It has several unbound text boxes and combo boxes in the form header to use to search. In the detail section I have the query fields using =Forms!frmName!fieldName or the Like equivalent. The whole thing works when I close the query, fill in the boxes in the header with data and open the query. I get the right data listed. But I want to have a button that causes the query data to be displayed in the form fields of the detail section. I hope I am being clear. Thanks, Scott
Go to the top of the page
 
June7
post Sep 21 2019, 01:33 AM
Post#2



Posts: 867
Joined: 25-January 16



Review http://allenbrowne.com/ser-62.html

Not really understanding what you are doing. That expression makes no sense to. If you want to provide db for analysis, follow instructions at bottom of my post.

This post has been edited by June7: Sep 21 2019, 01:35 AM

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
brastedhouse
post Sep 21 2019, 07:08 AM
Post#3



Posts: 102
Joined: 16-March 15
From: Chautauqua, NY


Hi, I have been trying to get Allen Steele's code to work for quite a while. I have rebuilt it several times and it always errors out at the filter on line. In the meantime I am trying to use a query with references to the text boxes as criteria. I am looking for a way to use a button to get the data to display on a form and not open the query directly on the screen.

1. So I have a form that is bound to a query. The query works.
2. In the header I have a series of unbound text boxes and combo boxes. (very similar to Allen Steele's example)
3. In the detail section I have fields from the bound query as a continuous form. (again, very similar to Allen Steele's example)
4. The query can be opened and show the correct data from the open and filled out form.
5. I would like to use a button to populate the continuous form with the search data from the query instead of opening the query as the visible result.

Does that help?

Thanks for taking the time to look at this, Scott
This post has been edited by brastedhouse: Sep 21 2019, 07:10 AM
Go to the top of the page
 
projecttoday
post Sep 21 2019, 07:50 AM
Post#4


UtterAccess VIP
Posts: 11,056
Joined: 10-February 04
From: South Charleston, WV


QUOTE
Allen Steele


Luckily, Allen Browne doesn't post here (I don't think). But Doug Steele does.

--------------------
Robert Crouser
Go to the top of the page
 
GroverParkGeorge
post Sep 21 2019, 08:05 AM
Post#5


UA Admin
Posts: 35,847
Joined: 20-June 02
From: Newcastle, WA


Allen Browne has been retired from Access Development for many years, although he maintains his foundational website which we all use so frequently. The last I heard he had accepted a position as head of a school but that was several years ago now.

Anyway, it would probably be more fruitful if you can provide a sample accdb with the tables containing only sample data and the form and queries. That way we can determine what is happening "behind the scenes" and offer useful suggestions.


--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th October 2019 - 04:34 AM