Hi folks! I previously posted a question about cascading combo boxes here, but it became more about redesigning the database. Now, I'm having trouble with my forms using this new database design, which is attached with all forms, queries, tables (clam_test3.zip).
In my main form (and tblMain), I have a field called Port. There is a lookup table for the options for Port in luPort. I created a combo box using the luPort values to populate the Port field in tblMain. I have and Area field in two other tables (yes, these are different information): tblEffort (where we count # people in Area) and tblInterviews (where take info from individuals at Area). I have a subform for populating tblEffort and a subform for tblInterviews. I have combo boxes for Areas (referencing lookup tblAreas) for both these subforms. The goal is to get only the options for each port in the subforms based on the selection in the main form.
There are probably many ways to create cascading combo boxes, but my lack of vba programming experience led me to trying a simple process of calling up a query (qryAreas) and using the Forms!fmPort!cboPort criteria in the query Design View for the query. In the After Update, I added the code line: me.cboPort.Requery. However, I get a pop-up asking me to manually input the port, so I'm clearly not doing this correctly. Other things in my forms aren't working either (yes/no boxes aren't checking, etc) so I'm thinking there is an underlying problem with the form parent-child relationships that I've screwed up. I really appreciate any time you can take to look at the forms.