advice on method to use

[mollycase]

Hi all -

I'm not sure if I should use a subform, a macro, something on the switchboard...

I am using the Issues db template. What I'd like to happen is that if I select a particular category (Cell - Service change), in the Comments text box, some fields will pop up that pertain to that issue, like cell #, txt plan, data plan, device. But there would be different questions for each category and some would have none.

This is just a personal thing for me to use to keep track of stuff at work. I want the simplest thing possible.

I was thinking a macro could paste text based on a selction in the listbox, but have never worked with access macros, only excel.

Ideas?

Thanks!

 

[The_Doc_Man]

Search this forum for the topic of "cascading combo boxes" - which is related to the idea of limiting what you see to be consistent with something already chosen.

This is a form-related topic so for it to work, you need to think "forms"

 

[mollycase]

thanks for the suggestion...but i'm not sure if cascading combos will work because i have info i need to fill in and the blanks would be different depending on the issue.

if i select "cell service" i would want

cell number
plan?
data?
device

to show up in the comments box, which is just a big text box. they don't need to be actual fields. it's just a reminder to me to make sure i get certain information.

i've attached the database so you (and others) can see what i mean. prolly should have done that first

 

[mollycase]

thanks pat - that sounds like something i could figure out without too much pain.

i'm still open to any other ideas from the hive mind, of course!