Home Forums Microsoft Access Microsoft Access Cascading (filtered) combo boxes in a datasheet or continuious form RE: Cascading (filtered) combo boxes in a datasheet or continuious form

  • Regarding the size growth, the first question is whether you have done a compact and repair? It's much more important in .accdb and .mdb files than it is with .adp files. The former file types will always be a fair bit larger, as you are storing most of the logic in the front-end instead of the back-end, but unless you have many forms and reports I wouldn't expect that kind of size. For example, we have an app that has about 100 forms and 70 reports, and quite a bit of VBA logic, and in a compacted state it runs around 25 to 30 MB.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!