Creating a Search Box?

[Candy_Tech]

Hello,
I am working on a project using Microsoft Access 2013. *Disclaimer- My programming skills are little-to-none*
I am in need of assistance creating a search box to find specific data in a report. My report is a nutritional table; the report is filled with different pieces of data from a table I made on Access. I made the report work, but need to figure out a way to quickly search for specific labels. I want to search for the labels by item number.


Can someone please give me an idea on how to create a search box in Access?
Any information is greatly appreciated!

[andy49]

https://answers.microsoft.com/en-us/...c-f91ed7b6ec09

Any use


Sent from my iPhone using Tapatalk

[ranman256]

When you type in the textbox, the AFTERUPDATE will filter the results.....

sub txtFind_afterupdate()

If IsNull(txtFind) then
    Me.filterOn= false
else
   Me.filter="[field]='" & me.txtFind & "'"
   me.filterOn = true
end if
end sub