Simple DB need form advice

[nsohenick]

I am creating a very simple database. It is a knowledge base. I have 2 tables. 1 for Departments, the other for Issues and resolutions. I want my form to work so that when you pick a department from a drop down, you see only issues regarding that department in a second drop down. Thr resolutions will show in a text box below.

Do I need intricate programming to create this? I created the tables and forms. I guess I need help with a query somewhere.


Thanks!

 

[Hayley Baxter]

I think what you are looking for is cascading combo boxes where your selection from the first combo limits the choices for the second combo.

Have a look at this example and see if this looks similar to what you are after.

There's an Access 97 and 2000 version attached.

http://www.access-programmers.co.uk...hreadid=48343&highlight=cascading+combo+boxes

Hay

 

[nsohenick]

Thanks. It got me started. My db is much simpler. Maybe you could have a look. I only have 2 levels and want to display a text box with a value in the second table. My combo boxes are working, but the text box shows "#Name?"


Thanks, Hay

 

[Hayley Baxter]

sure no problem, can you post up your db then or if it's too big you can send it to me Here

 

[Hayley Baxter]

Sorry for not getting back to you sooner Nicole..was a little busy yesterday.

Anyhow I think this is what you want.

Hay

 

[nsohenick]

No problem I was on the beach for a week anyhow. Thank you that did it.

Thanks a lot,

Nicole

 

[Hayley Baxter]

No problem I was on the beach for a week anyhow. Thank you that did it.

Thanks a lot,

Nicole

Not bad for some, glad it helped

Hay