This was tricky to figure out. The Microsoft help website talks about "drilling down" through the structure of the database. The tricky part was trying to figure out what table was being referenced in the combo boxes and the relationship between those tables as far as parent and child. The parent, or combo box 1, can have a one-to-many relationship with the child. The structure of the tables is very important in trying to get this to work. Thanks for sharing austin72406. You really get this stuff!
Great video. I've ran into a problem though and I've looked at it from every angle and can't seem to figure it out. I have 4 levels of cascading combo boxes. When I select a value for the first box, the second box filters the available options perfectly and I'm able to select one just fine. When I get to the next, third combo box however, I immediately get the "This expression is typed incorrectly or it is too complex..." error and there are no values available to select from. Same story for the 4th one. The queries for each of the 4 combo boxes reference are virtually exactly equivalent to each other as well as the criteria code. I just can't figure out why the concept works fine for the second box but won't work for the third or fourth when they, again, are virtually exactly the same. I have the right VBA to requery the next box as each box is filled, each row source is pointing to the right place, the boxes, queries, and tables are all named and referenced correctly, everything seems to be right, but it won't still work. I'm completely stuck. Anyone?
Thank you for you explanation, it was really clear!!!. I have only one question, I did it right, But I would like to have the second combo box to become empty if I change the first combo box. In your example it happens, but in mine it doesn't, can you help me?
Hello, for the 2nd combo box the query for your example uses [Form]![Customer]![Combo219] I couldnt get the drop down when I type it out. When I enter they prompt me that it is invalid. Why is that so?
Hi, How should we auto populate the all values in diffrent text box depending upon the selection of the one dropdown value?? Means, Suppose we select the specific value from dropdown and once we select the value from dropdown then text box automatically fetch and fill the data. i want this in ADF view criteria
Sirji, you understand the way O really is very good .. It gives us a lot of knowledge… Sir, a search box from which we search and create a check box (such as a class) and a check box button can be obtained by clicking on it (such as its Aadhaar number, its mother's name…). ...
when i was creating second combo box "Create Box Wizard" at first step "Third Option is missing in my Access 2010 & 2013 too. where this line is written "Find a record on my form based on the value I selected in my combo box". ??? so how can resolve it ??? any help ??
Need to update the rowsource data on the second combo box. need to link certain field to the first combo box. And need to put the code refresh the second combo box after the first combo box selected. It will be under the After Update Event on the first combo box.
Hi! How could we use 4or5 combobox independence from combobox1to combobox5 and switch from 5 independence to1combobox. I mean can search data like state ,city ,commune to provinces and from provinces .....to state ?
How do you get the value in Combo Box 2 (Select Customer Name) to reset back to "blank" every time after you update the customer type? Thank you for the tutorial ... very easy and powerful....I am working on a task similar to the idea presented here though everything works perfectly fine ONLY the re-query function doesn't reset the value back to "null" but rather keep the previous value which is very confusing to the user if they have to do multiple orders. Thanks in advance!
please watch video every step you might missed some part.on the AfterUpdate Event of 1st combo box (Customer Type) need to have code as me.2ndComboboxName.requeryalso on the data/row source of 2nd combo box needs to have the customer type field set the criteria to the 1st combo box.
Hello! I have a combo box for Contracts and another combo box that displays the Supplier based on the selected contract. All these created under the instructions of the video. The problem is that whichever Contract I choose from the first combo box, I always get only one of my two saved suppliers (and that is not the corresponding supplier!). Is there something in the property sheet that needs to be changed?
Hi, sir what if i change the value of the first combobox? i want when i do these it also refresh the second combobox and the appear the value related in the first combobox or the combobox is bcanged to empty i don't want the previus value is still shown it the box. thank you
you will need to edit the row source of second combo box in which the field related to the first combo box. also after the select the value on the first combo box you will need to refresh the second combo box on the After Update Event of First combo box.
Sir how i edit the row source of second combo box with the field related to the first combo box?! Please explain to me because i am new in the access. Thank you.
Is there anyway I can get your consultation a couple of questions I have? I want to make a combobox that when you select a value (like a state) all the values for that state show up, from a different table that is connect to the one that is the source of the combo box. Any insight?
I watched the video but your method is not how I need to get the application to operate. I need to be able to use one form to search the state from a combo box, then once that state is searched, clicking on the value in the box then populates a different form by which all of the laws in that state are displayed.
Dear can I but a condition or a constrain on combo box to show specific rows like upgrading a student degree e.g. if he is BA then the only choices are shown MA , PHD, or proff. and if he is MA then the only choices are shown PHD, or Proff
Thanks you for sharing this video. Any idea on getting cascade combo box working in Navigation form? The above works fine when I open the form directly, but falls down when placed in a navigation form. Any help with this would be gratefully received.
you will need to update the Row Source of data on the second combo box in the query from [Forms]![Customer]![Combo219] to [Forms]![Navigation Form].[Form]![NavigationSubform]![Combo219]
austin72406 Thank you sir. Try to update the Row Source as indicated. But keep getting prompt to Enter Parameter Value, Forms!Navigation Form.Form!NavigationSubform!Combo219. Not sure what I did wrong. Just starting to learn Access and have no programming background.
austin72406 Thank you sir! Have been cracking my head & wonder why it does not work.LOL. Just replace to [Forms]![Master Order].[Form]![NavigationSubform]![Combo219] and yippe it works! As my main form is call Master Order. Thanks again.
Ann Tan Opps...Try to put the same on 2nd tab of main navigation form and it doesn't work. Asked to enter parameter value. It works on 1st tab smoothly.
Thanks Austin, this seems to work for the first form (top tier). However if there is a another navigation form within that form (2nd Tier) it doesn't find it. For example If you have a Navigation form that has a tab called "Search" that opens "FrmSearch" then a navigation form within "FrmSearch" with two tabs "Table View" and "Form View". When individuals click "Form View" it will open a form called "FrmSearchFrm" the query can't find any value on that form.
+austin72406 I dont have the third option "Find a record on my form...." because my Form doesn' thave a Record Source. If I select a Table for Record source, all the other boxes in my Form stop working.
I wish you would have talked about the query that you made ahead of time that was the row source for your second combo box
This was tricky to figure out. The Microsoft help website talks about "drilling down" through the structure of the database. The tricky part was trying to figure out what table was being referenced in the combo boxes and the relationship between those tables as far as parent and child. The parent, or combo box 1, can have a one-to-many relationship with the child. The structure of the tables is very important in trying to get this to work. Thanks for sharing austin72406. You really get this stuff!
Austin
One more time very big thanks for your tutorial - its very useful.
You videos are great. I have learned alot from them :) thank you for being so helpful
you're welcome.
Great video. I've ran into a problem though and I've looked at it from every angle and can't seem to figure it out.
I have 4 levels of cascading combo boxes. When I select a value for the first box, the second box filters the available options perfectly and I'm able to select one just fine. When I get to the next, third combo box however, I immediately get the "This expression is typed incorrectly or it is too complex..." error and there are no values available to select from. Same story for the 4th one.
The queries for each of the 4 combo boxes reference are virtually exactly equivalent to each other as well as the criteria code. I just can't figure out why the concept works fine for the second box but won't work for the third or fourth when they, again, are virtually exactly the same.
I have the right VBA to requery the next box as each box is filled, each row source is pointing to the right place, the boxes, queries, and tables are all named and referenced correctly, everything seems to be right, but it won't still work.
I'm completely stuck. Anyone?
I am from rural area but trying to do automate programs through access. And from lot of days I am searching this thing after all at last I got it.
Excellent tutorial!! Thank you!
Hi ! Any Idea what can I do if I added A third Combo box that depends on the Value of the filtered second combo ?
Thanks for your clip, this helps me a lot
Thank you for you explanation, it was really clear!!!. I have only one question, I did it right, But I would like to have the second combo box to become empty if I change the first combo box. In your example it happens, but in mine it doesn't, can you help me?
Thank you. I’ve been trying to do this for... days. I’ve been doing it backwards.
Thank you so much for posting this. It really helped me out!
Thank you! That was easy and worked well.
Hello,
for the 2nd combo box the query for your example uses [Form]![Customer]![Combo219]
I couldnt get the drop down when I type it out. When I enter they prompt me that it is invalid.
Why is that so?
Hi,
How should we auto populate the all values in diffrent text box depending upon the selection of the one dropdown value??
Means, Suppose we select the specific value from dropdown and once we select the value from dropdown then text box automatically fetch and fill the data.
i want this in ADF view criteria
Thank you. Now, I can manipulate my combo box :D
Sirji, you understand the way O really is very good .. It gives us a lot of knowledge…
Sir, a search box from which we search and create a check box (such as a class) and a check box button can be obtained by clicking on it (such as its Aadhaar number, its mother's name…). ...
thank you but how to make default value for second combobox and still be able to see whole list depending on first combo...
when i was creating second combo box "Create Box Wizard" at first step "Third Option is missing in my Access 2010 & 2013 too.
where this line is written "Find a record on my form based on the value I selected in my combo box". ??? so how can resolve it ??? any help ??
Need to update the rowsource data on the second combo box. need to link certain field to the first combo box.
And need to put the code refresh the second combo box after the first combo box selected. It will be under the After Update Event on the first combo box.
Is it possible to do such on MS excel useform using vba ?
Thank you for this video nice one
Thx i was looking how to do this.
Hi Sir, How i can change the second combobox to checklist combobox with the same conditions ?
Thank you
sir is there any solution to avoid error when it put on navigation bar?
Great Video. Thank you
Hi! How could we use 4or5 combobox independence from combobox1to combobox5 and switch from 5 independence to1combobox. I mean can search data like state ,city ,commune to provinces and from provinces .....to state ?
Thanks!!!! Easy & Helpful
Thank you!
How do you get the value in Combo Box 2 (Select Customer Name) to reset back to "blank" every time after you update the customer type?
Thank you for the tutorial ... very easy and powerful....I am working on a task similar to the idea presented here though everything works perfectly fine ONLY the re-query function doesn't reset the value back to "null" but rather keep the previous value which is very confusing to the user if they have to do multiple orders. Thanks in advance!
please watch video every step you might missed some part.on the AfterUpdate Event of 1st combo box (Customer Type) need to have code as me.2ndComboboxName.requeryalso on the data/row source of 2nd combo box needs to have the customer type field set the criteria to the 1st combo box.
Hello! I have a combo box for Contracts and another combo box that displays the Supplier based on the selected contract. All these created under the instructions of the video. The problem is that whichever Contract I choose from the first combo box, I always get only one of my two saved suppliers (and that is not the corresponding supplier!). Is there something in the property sheet that needs to be changed?
Did you have a code to requery the second combobox on the after update of first combobox?
How to hide unhide a subform with combo box selection?
Hi, sir what if i change the value of the first combobox? i want when i do these it also refresh the second combobox and the appear the value related in the first combobox or the combobox is bcanged to empty i don't want the previus value is still shown it the box.
thank you
you will need to edit the row source of second combo box in which the field related to the first combo box.
also after the select the value on the first combo box you will need to refresh the second combo box on the After Update Event of First combo box.
Sir how i edit the row source of second combo box with the field related to the first combo box?! Please explain to me because i am new in the access.
Thank you.
Super Video Thank you...So much...
Is there anyway I can get your consultation a couple of questions I have? I want to make a combobox that when you select a value (like a state) all the values for that state show up, from a different table that is connect to the one that is the source of the combo box. Any insight?
that's simple. search by using combo box here: th-cam.com/video/8N1hRBdsI1s/w-d-xo.html
I watched the video but your method is not how I need to get the application to operate. I need to be able to use one form to search the state from a combo box, then once that state is searched, clicking on the value in the box then populates a different form by which all of the laws in that state are displayed.
Dear can I but a condition or a constrain on combo box to show specific rows like upgrading a student degree
e.g. if he is BA then the only choices are shown MA , PHD, or proff.
and if he is MA then the only choices are shown PHD, or Proff
Yes, you can do it either from VBA code or link to another table from the data source of combo like shown on the video.
Thank you
Thanks you for sharing this video. Any idea on getting cascade combo box working in Navigation form? The above works fine when I open the form directly, but falls down when placed in a navigation form. Any help with this would be gratefully received.
you will need to update the Row Source of data on the second combo box in the query from [Forms]![Customer]![Combo219] to [Forms]![Navigation Form].[Form]![NavigationSubform]![Combo219]
austin72406
Thank you sir. Try to update the Row Source as indicated. But keep getting prompt to Enter Parameter Value, Forms!Navigation Form.Form!NavigationSubform!Combo219. Not sure what I did wrong. Just starting to learn Access and have no programming background.
Ann Tan this: [Forms]![Navigation Form].[Form]![NavigationSubform]![Combo219] make sure you have a correct form name and combo box name
austin72406
Thank you sir! Have been cracking my head & wonder why it does not work.LOL. Just replace to [Forms]![Master Order].[Form]![NavigationSubform]![Combo219] and yippe it works! As my main form is call Master Order. Thanks again.
Ann Tan
Opps...Try to put the same on 2nd tab of main navigation form and it doesn't work. Asked to enter parameter value. It works on 1st tab smoothly.
In a combo box third option find a selection is nor showing in my ms access
+ran meet mine either. Any update?
very helpful video
How would you amend this to get it to work on a subform?
Actually I've worked it out. Thanks for posting another helpful Access video.
I'm trying to do this right now, any pointers?
Hi how do you reference a combobox on a navigation form within another navigation form (two tier) thanks
it is about referencing to the navigation form.
it will be like:
Forms![Navigation Form].Form.[NavigationSubform].Form.combobox
Thanks Austin, this seems to work for the first form (top tier). However if there is a another navigation form within that form (2nd Tier) it doesn't find it. For example If you have a Navigation form that has a tab called "Search" that opens "FrmSearch" then a navigation form within "FrmSearch" with two tabs "Table View" and "Form View". When individuals click "Form View" it will open a form called "FrmSearchFrm" the query can't find any value on that form.
how about:Forms![Navigation Form].Form.[FrmSearch].Form.[NavigationSubform].Form.combobox
Nice 👍
good explained
Good Example
When I click combo box, I don't have the third option. Any suggestions?
please explain more in detail for your question.
+austin72406 I dont have the third option "Find a record on my form...." because my Form doesn' thave a Record Source. If I select a Table for Record source, all the other boxes in my Form stop working.
Very Good
Thanks
great job, anyone can help me with this same situation BUT IN WORD PLEASE
yeah. the query was not discussed. In the end, this video was a waste of time
You made this hard. There is an easier way.