Access Search Seminar

Free Lessons
Courses
Seminars

TechHelp
Fast Tips
Templates

Topic Index
Forum
ABCD

Home Courses Seminars Templates TechHelp Fast Tips Forums Help Contact Join Order Logon

Access Search Seminar
By Richard Rost

Richard Rost on Twitter

Richard Rost on LinkedIn

Email Richard Rost

10 years ago

Back to Access Search Seminar

text box filter combo box Upload Images Link
Emad Al-Baghli
13 months ago

Hi, I have combo box a lot of Names and I want to put text box next to it that if I type any letter in the text box it will filter this combo box to make it faster to pick

kindly, can you change my name to "EMD" I do not want my full name show up :) in forums and conversations public plz

Adam Schwanz
13 months ago

What you need to do is make an after update event in your text box to set the row source of your combo box. Then use the WHERE to filter based on your text box. Something like

ComboName = "SELECT ID From TableT WHERE ID Like """ & TextBoxName & "*"""

Adam Schwanz
13 months ago

Forgot to add ComboName.RowSource not just ComboName

Ray White
13 months ago

In the Combo Box just use the search as you type code.
That way the Combo Box will not start loading any records until you start typing
Richard shows how to do that somewhere in here.

Emad Al-Baghli
13 months ago

Kindly can you show me how to do combobox as you type by MACRO and VBA
I will be appreciative

Adam Schwanz
13 months ago

The search as you type is almost identical to what I just told you as long as it's only one field you're sorting by.

This has the search as you type lessons = https://599cd.com/site/courselist/seminars/access-search/

No idea how you'd do it with a macro and I don't even want to try LOL. VBA much easier.

Emad Al-Baghli
13 months ago

Mr.Adam,
I am enrolled to Access Search Seminars, what is the lesson number?
Because my VBA at my work is blocked for security reasons, that is why if you kindly give it a try by MACRO I will be appreciated

Adam Schwanz
13 months ago

I think it's lesson 33. Search as you Type. You can try to mimic that into a macro or maybe Rick knows a way but I don't know very much about macros. I ditched them the instant I learned VBA.

Emad Al-Baghli
13 months ago

I did it!
I have text box next to combobox and I go to the combobox query design I put the path that linked to textbox, and if I write something in text box it will filter the combobox,
but the problem is if I hit new record any thing I type still remain in text box how can I say to Access clear textbox after hit add new record or go to next record?

Kevin Robertson
13 months ago

Clear the textbox in the OnCurrent event

TextBoxName = ""

Emad Al-Baghli
13 months ago

Kevin
OnCurrent event on the form or in control?

Kevin Robertson
13 months ago

OnCurrent is a form event

Emad Al-Baghli
13 months ago

Kevin,
I go to the Form,OnCurrent Event, Macro, and I chose SetProperty, Control Name, Property Value, Value=""
I put it in Expression Builder same issue =[Searcا1]=""
I could not use VBA becuse it is blocked at work, I can use only Macro,Expression builder, and Query
but it does not work, also in Same form I have more that one control with same job for filtering
Kindly can you explain it more to me

Kevin Robertson
13 months ago

In the Macro Builder:

- Click in the Show All Actions button on the ribbon
- Choose SetValue

Item = TextboxName
Expression = ""

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Search Seminar

Subscribe

You may want to read these articles from the 599CD News:

5/16/2022	Referential Integrity
5/15/2022	Invoicing Member Discussion
5/13/2022	Multivalued
5/12/2022	Number Field Size
5/11/2022	Create Word Document
5/11/2022	Export to Word
5/10/2022	On Click Event Timing
5/9/2022	Invalid Use of Null
5/7/2022	Event Handler
5/6/2022	Database Title & Icon

Learn

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...

Customers

Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email

Info

Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus

Help

Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services

About

Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List

Order

Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale

Contact

Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey

YouTube Channel