Thanks. This works, but I'm still unsure how to use this to create the new table.

Lutz:

Wow! This is some idea, Thanks. Do you think this approach can be used with xml files. I must admit I'm a little intimidated by the whole...

Steve:

Thanks for the response. It definitely makes sense to me, but I'm kinda strapped with screen real estate. So I can only use one list box. As...

How did you use views for combo boxes? I'm not sure if this is similar to what I'm trying to solve.

I tried this again on a flat table without any combo-boxes etc. Also without any refresh, requery on any events. Just a datasheet view form with a table...

Thanks for all the help so far.  I'm still having trouble getting single quotation marks around the Tplan variable.  It's driving me bonkos.  I tried the syntax you suggested for...

Tal:

Thanks for your reply.  You understand the script correctly. The main problem I'm having is the WHERE statement.  It doesn't seem to work wherever I put it.  With the above code,...