Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Old 12-13-2015, 05:45 PM   #1
Newly Registered User
Join Date: Dec 2015
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
OzGreg is on a distinguished road
Exclamation Combo Box Searching

Hi all

I have caused a little bit of confusion with my earlier post and am re-posting my question sorry.

I am wanting to get the combo box to display the multiple search matches in a drop down as I type each letter. Then I select the appropriate one from the drop down to display the details on my sub-form. Pic attached.

Can someone help, Thanks Greg
Attached Images
File Type: jpg Capture.jpg (75.9 KB, 23 views)

OzGreg is offline   Reply With Quote
Old 12-13-2015, 06:34 PM   #2
Newly Registered User
Join Date: Feb 2001
Location: Houston,Texas USA
Posts: 4,018
Thanks: 6
Thanked 106 Times in 104 Posts
llkhoutx is on a distinguished road
Re: Combo Box Searching

Ordinarily subforms usually tumble wit a main form.

What's the subform to display before the combo box row is selected?

One method is to use the subform Filter and FilterOn properties be set of th combo box AfterUpdate event.

What are you going to do on the subform, after the records are filtered?
Get the job done right, rather than do the right job.
Do it fast or do it right. Teach a man a fish . . .
If it ain't broke, don't fix it.
Note that I don't open posted databases, period.
llkhoutx is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
searching in a combo box with the help of * benjamin.grimm Queries 3 09-26-2013 07:54 AM
Combo text from one form to another, Searching using combo box me_ntal Forms 1 06-23-2011 05:33 PM
Searching using combo box input key1pop1 Modules & VBA 1 06-11-2011 06:47 AM
Searching using combo box pmckeown Forms 4 02-17-2009 11:31 AM
Searching with Combo Box gear General 1 08-08-2007 12:48 AM

All times are GMT -8. The time now is 06:40 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World