Taras
asked on
Not In the list cascading combox
Access 2010, How to update cascading combo boxes: cboShopCountry, cboShopState, cboShopCity with new values.
Can it be done through Not In the list event?
Do you have example?
Can it be done through Not In the list event?
Do you have example?
ASKER
Rey.
I mean what I said; you did not read my question.
I did not ask how to update one combo box with new value that is not one of values of list value or is not in the table/query depends what source combo box have.
I asked how to add new values in combo boxes that are connected as cascading combo boxes.
It means Selection that you pick up in cboA drives options in cboB and selection that you pick up in cboB drives option in cboC.
Now I want to give a user option during entry data process on the form to add new value in existing values in those combo boxes, not just to pick up one of those that are already in box A,B or C.
For not cascading combo box I will use Not in the List event, I know how to do that.
However those are cascading combo boxes as I said in question . Not single combo box with list value or table/query as a source.
How to do this ?
I mean what I said; you did not read my question.
I did not ask how to update one combo box with new value that is not one of values of list value or is not in the table/query depends what source combo box have.
I asked how to add new values in combo boxes that are connected as cascading combo boxes.
It means Selection that you pick up in cboA drives options in cboB and selection that you pick up in cboB drives option in cboC.
Now I want to give a user option during entry data process on the form to add new value in existing values in those combo boxes, not just to pick up one of those that are already in box A,B or C.
For not cascading combo box I will use Not in the List event, I know how to do that.
However those are cascading combo boxes as I said in question . Not single combo box with list value or table/query as a source.
How to do this ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<Not single combo box with list value or table/query as a source.>
so, how do you select a value from cboA?
so, how do you select a value from cboA?
ASKER
Scott.
I am doing that second part that you referring to.
Let say I have tables tblCountry, tblState, tblCity. I can create relationship between them and enforce referential integrity.
Let say in table Country I have three entries Germany, USA, France.
When I pick up country USA I have only four states (Michigan, Texas, Arizona, Colorado) showing in State combo box those ones that I have shops in not all states.
Then when I pick up one of those states e.g. Michigan then in City combo box I have only e.g. five cites, those five are cites that I have shops in from state Michigan.
Following your suggestion let say
Now I want to add new shop in city Peterborough that is in province/state Ontario that is in country Canada.
You are suggesting to do that trough new form that will pop up at NIL of combo box cboCountry.
Then this new form will have fields for entering new Country , State/Province and City ?
Can you give me more detail or one example what do next. I have some clue but not sure is this ok or possible??
Are you suggesting on this new form those tree boxes for entering new Country, State and City to be combo boxes or simple text boxes?
Let say they are combo boxes, then why I need to go at NIL to this new form when I had those three combo boxes on existing form.
Further
If they are combo boxes on this new form, then combo box cboCountry is base on tblCountry and cboState and cboCity are based on queries as we need cascading connection.
Those two queries will have foreign keys in that will come from cboCountry(query for cboState record source) and cboState(query for cboCity record source)
Then in after update event of each of those three combo boxes I will do require of other two.
Is that proper and possible way to try??
I am doing that second part that you referring to.
Let say I have tables tblCountry, tblState, tblCity. I can create relationship between them and enforce referential integrity.
Let say in table Country I have three entries Germany, USA, France.
When I pick up country USA I have only four states (Michigan, Texas, Arizona, Colorado) showing in State combo box those ones that I have shops in not all states.
Then when I pick up one of those states e.g. Michigan then in City combo box I have only e.g. five cites, those five are cites that I have shops in from state Michigan.
Following your suggestion let say
Now I want to add new shop in city Peterborough that is in province/state Ontario that is in country Canada.
You are suggesting to do that trough new form that will pop up at NIL of combo box cboCountry.
Then this new form will have fields for entering new Country , State/Province and City ?
Can you give me more detail or one example what do next. I have some clue but not sure is this ok or possible??
Are you suggesting on this new form those tree boxes for entering new Country, State and City to be combo boxes or simple text boxes?
Let say they are combo boxes, then why I need to go at NIL to this new form when I had those three combo boxes on existing form.
Further
If they are combo boxes on this new form, then combo box cboCountry is base on tblCountry and cboState and cboCity are based on queries as we need cascading connection.
Those two queries will have foreign keys in that will come from cboCountry(query for cboState record source) and cboState(query for cboCity record source)
Then in after update event of each of those three combo boxes I will do require of other two.
Is that proper and possible way to try??
ASKER
Thanks.
the on not in list event is use to add items to combo boxes lists.
see this link
http://support.microsoft.com/kb/197526
post back if this is not what you want/need