Cascading DropDowns With Subform

[dgreatjc]

I'm having a horrible time figuring this out. It's not from lack of trying. Any help would be wonderful.
On my proposal page, I want to select the "Type of Work" from a dropdown list, and then select the "Proposal Details" that filter out various types of work depending on what I selected at first.

I think it should be very simple, but I've been having a horrible time with this. Thanks for any help

 

[odin1701]

You could do it using SQL for your recordsource, and the different boxes change the WHERE clause. I can't look at your example as it's in an unrecognized format.

 

[vbaInet]

You could do it using SQL for your recordsource, and the different boxes change the WHERE clause. I can't look at your example as it's in an unrecognized format.

It's an Access 2007 db. You should upgrade to 2007 or wait for the ultimate 2010. 2007 has some nice features.

dgreatjc: Create a query based on your proposals table and use it as your main form's (i.e. Proposal form's) RecordSource.

 

[odin1701]

I've used 2007. I don't really care for what they have done moving things all around, and I hate the stupid Ribbon crap that they put in all the new O2K7 apps.

 

[vbaInet]

I've used 2007. I don't really care for what they have done moving things all around, and I hate the stupid Ribbon crap that they put in all the new O2K7 apps.

Oh the ribbon is great Have you tried creating a custom ribbon?

 

[odin1701]

I didn't know you could create a custom one. I haven't used it all that much, just enough to know that I don't like the ribbon...or at least the default one. I hate it when they move things around.

But my company is still on 2003. Would be quite expensive to do the upgrade for the number of systems we have.

 

[vbaInet]

I didn't know you could create a custom one. I haven't used it all that much, just enough to know that I don't like the ribbon...or at least the default one. I hate it when they move things around.

But my company is still on 2003. Would be quite expensive to do the upgrade for the number of systems we have.

That's Info Systems for you, you've just got to keep up
Yes you could create a custom one, adding built-in tabs or just using your own tabs. You have to use xml to create it though, and then use callbacks to make the controls do something. Pretty neat.