I hope some people will be so kind to help me with a form I'm having huge trouble with. I've attached a stripped back database (removed non-related tables and other forms and filled with test data that doesn't represent RL).
There are two forms here, both continuous:
The form:
Header: filters records on the body of the form. There are some cascading cbo fields:
Body. Again, there are some cascading cbo fields:
The problems. Where to start. Probably best that you download and see what's happening:
I had requery in a lot of these subprocess after a filter is done, but it didn't have any effect. Clearly I'm missing some crucial concept here....
There are two forms here, both continuous:
- fStaff
- fLocation
The form:
Header: filters records on the body of the form. There are some cascading cbo fields:
- cboFilterFIDFaculty
- cboFilterFIDSchool (depends on 1)
- cboFilterFIDSubject (depends on 2)
- cboFilterFIDSpecialism and cboFilterPointOfContact (both depends on 3)
Body. Again, there are some cascading cbo fields:
- cboFIDFaculty
- cboFIDSchool (depends on 1)
- cboFIDSubject (depends on 2)
- cboFIDSpecialism and cboFilterPointOfContact (both depends on 3)
The problems. Where to start. Probably best that you download and see what's happening:
- If using the test data already in there, using any record's subject, see what happens to some of the txtfields AND cbos when a subject is changed. The same oddness happens when adding in a new record.They only appear back when reopen the form.
- If you click on any child cbo (ie. subject) in the body, it's not filtering the list based on it's parent as it should be doing (I have On Click event to recheck what selection the parent cbo is) and then if I click on a record that's not using the same subject/school it turns it blank (although the data is still there in the table) - I assume again, this is because it's not rechecking it's parent.
I had requery in a lot of these subprocess after a filter is done, but it didn't have any effect. Clearly I'm missing some crucial concept here....