I want to be able to add a new form (Form 2) I have already created to another form. Form 2 being the subform. I have three fields in this for. One of these fields affects the other (both are combo boxes). When one selection is made in one combo box, the other will only display values related to that combo box e.g. select a country and only citys in that country are available for selection in the other combo box. I have this working when I created Form 2, but when I add it to Form 1 it doesn't work. It appears in Form View and the function doesn't work, all cities are available to choose from. What am I doing wrong? I believe I need to create the subform (form 2) from a Query? but I cannot figure out how to create the function in the query. Any advice? Any examples of such code I neeed?
Thankyou