Creating a functional searchbox on a report (1 Viewer)

vixinho

New member
Local time
Today, 18:51
Joined
May 11, 2020
Messages
8
Hello Access world. I have a database with multiple tables. I have created a query to provide specific data from various tables. I have then created a report from the query. Which code can I use to filter my report on key-up?
Or can I use a continuous form from the query as a subform for my report? What is the sample code in case of the continuous form report?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:51
Joined
May 7, 2009
Messages
19,169
report is not the best way to search.
use form instead.
use the report to show filtered result.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 15:51
Joined
Jul 9, 2003
Messages
16,244
From the nature of your question, I think my Search Form may be of interest to you. You can see it here on my website:-


Let me know if you want a free copy and I will tell you how to obtain the free version...
 

Users who are viewing this thread

Top Bottom