If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic filtering
What I want to create is a dynamic filter that will narrow down your choices
as you type in a combo box. I.E. The selection narrows as you type "a" will display all that starts with "a". Continue to type "ab" displays all that start with "ab" then by the time you have typed "aba" you may now only have 3 or 4 choices to choose from and clicking one will bring up that record for viewing or modification. I have seen it done in web based database front ends. Is there a way to do this from a form control? |
#2
|
|||
|
|||
Dynamic filtering
The standard form filter is:
Me.filter = "[youridfield] = """ & Me.combo# & """" Me.filteron=true Then check with Allen Browne at www.allenbrowne.com to get the search as you type part. "John F" wrote: What I want to create is a dynamic filter that will narrow down your choices as you type in a combo box. I.E. The selection narrows as you type "a" will display all that starts with "a". Continue to type "ab" displays all that start with "ab" then by the time you have typed "aba" you may now only have 3 or 4 choices to choose from and clicking one will bring up that record for viewing or modification. I have seen it done in web based database front ends. Is there a way to do this from a form control? |
#3
|
|||
|
|||
Dynamic filtering
That is the usual behaviour of a combo box. Just be sure the Auto Expand
property is set to Yes. -- Dave Hargis, Microsoft Access MVP "John F" wrote: What I want to create is a dynamic filter that will narrow down your choices as you type in a combo box. I.E. The selection narrows as you type "a" will display all that starts with "a". Continue to type "ab" displays all that start with "ab" then by the time you have typed "aba" you may now only have 3 or 4 choices to choose from and clicking one will bring up that record for viewing or modification. I have seen it done in web based database front ends. Is there a way to do this from a form control? |
#4
|
|||
|
|||
Dynamic filtering
Yes but by default it shows all. What Im looking for is to only display
matching criteria hopefully limiting possibilities of mis-selection. The above post appears to fit the bill, but I have not been able ti investigate fully. Thanks. "Klatuu" wrote: That is the usual behaviour of a combo box. Just be sure the Auto Expand property is set to Yes. -- Dave Hargis, Microsoft Access MVP "John F" wrote: What I want to create is a dynamic filter that will narrow down your choices as you type in a combo box. I.E. The selection narrows as you type "a" will display all that starts with "a". Continue to type "ab" displays all that start with "ab" then by the time you have typed "aba" you may now only have 3 or 4 choices to choose from and clicking one will bring up that record for viewing or modification. I have seen it done in web based database front ends. Is there a way to do this from a form control? |
#5
|
|||
|
|||
Dynamic filtering
Gets very close to what I am looking for. I will take a bit of modification
but I think that I can make it work. Thanks "Golfinray" wrote: The standard form filter is: Me.filter = "[youridfield] = """ & Me.combo# & """" Me.filteron=true Then check with Allen Browne at www.allenbrowne.com to get the search as you type part. "John F" wrote: What I want to create is a dynamic filter that will narrow down your choices as you type in a combo box. I.E. The selection narrows as you type "a" will display all that starts with "a". Continue to type "ab" displays all that start with "ab" then by the time you have typed "aba" you may now only have 3 or 4 choices to choose from and clicking one will bring up that record for viewing or modification. I have seen it done in web based database front ends. Is there a way to do this from a form control? |
#6
|
|||
|
|||
Dynamic filtering
The post from Golfinray is very close to what I am looking for. It allows a
person to find items in the middle of the field. Which allows the operator to not have to know if the record has "The" in front and still find the information. But thank-you. "Klatuu" wrote: That is the usual behaviour of a combo box. Just be sure the Auto Expand property is set to Yes. -- Dave Hargis, Microsoft Access MVP "John F" wrote: What I want to create is a dynamic filter that will narrow down your choices as you type in a combo box. I.E. The selection narrows as you type "a" will display all that starts with "a". Continue to type "ab" displays all that start with "ab" then by the time you have typed "aba" you may now only have 3 or 4 choices to choose from and clicking one will bring up that record for viewing or modification. I have seen it done in web based database front ends. Is there a way to do this from a form control? |
Thread Tools | |
Display Modes | |
|
|