Search codes (1 Viewer)

Valient

Member
Local time
Today, 02:25
Joined
Jun 21, 2021
Messages
48
Hi AW Team,

I would like to ask your help on how i can create a button that can search for the word like how google search works.

I created a form call "form1" and I link to the "table1". Then make it a split form.
On the Split form I added "unbound" and button and "Clear".

What I want to achieve is:
When I type "A" on the unbound, it will give all words starts from A from the Control Number,
until I completed the word "AA1", then when click "AA1", all words under Control Number will display.

The button "Clear" will clear all the added word in the box.


1686382863098.png


I'm new in coding and do not know how to do it, so I attached the sample file, hoping someone can put codes on it and help


Thank you very much
 

Attachments

  • Database1.accdb
    516 KB · Views: 65

Gasman

Enthusiastic Amateur
Local time
Today, 00:25
Joined
Sep 21, 2011
Messages
14,310
Search FAYT here on this site.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 16:25
Joined
Oct 29, 2018
Messages
21,474
There's a sample here.
 

Users who are viewing this thread

Top Bottom