Recent content by kesmith

The db2.mdb example you provided is exactly the type of cascading combo box problem I am trying to deal with, except I need to take it two more times (ie. two more combo boxes that use the same source list but do not allow the user to reselect previously selected items.) I have tried to do it...

How about merging cells in the upper table to make it large enough? That would allow you to have smaller cell size in the lower tables.

Bob, Your suggestions were on the money! Works the way it is supposed to now. Greatly appreciate your help. Ken

I'll give your suggestions a try and see what happens. Thanks, Ken

The following is a VBA module in an Excel 2007 spreadsheet. It works fine when the database is ".mdb" (Access 2003) but not when it's ".accdb" (Access 2007). I tried the simple thing of changing the ofn.lpstrFilter line to .accdb vice .mdb but that didn't work, other than to make the .accdb file...

The following is a VBA module in an Excel spreadsheet. It works fine when the database is ".mdb" but not when it's ".accdb". I tried the simple thing of changing the ofn.lpstrFilter line to .accdb vice .mdb but that didn't work, other than to make the .accdb file visible in the open file window...