One ComboBox dependent on another

[Guest]

Hello All,

I've made a successful career of prowling the community looking for answers,
but this is the first time I've ever posted -- I'm absolutely desperate!

There was one string of messages that addressed this issue in 2004, but it
was never completed and hasn't helped me. I am working on a database that
will used to input data every quarter. In order to make the tedious process
as user-friendly as possible, I am trying to set the form up to make it just
so.

The form, which is bound to the table, is essentially a series of combo
boxes each with defined options, to avoid mistakes. In order to limit
errors, I have two combo boxes, one of which I'd like to make dependent on
the other.

I would like the options in cboSubCategory to be based on the user's input
to cboCategory. I would like all the input to be recorded in my data (right
now, cboCategory is unbound, and cboSubCategory is bound; remember, the form
itself is also bound -- I keep pointing this out because I think it makes a
difference? It might not, but I'd really like to find out!)

What can I do?? Thank-you in advance for any help!

JlR

 

[SusanV]

Perhaps this link will clear things up for you:
http://www.fontstuff.com/access/acctut10.htm

 

[Guest]

Thanks! I used pieces of this and pieces from the 2004 string and got it
figured out. I let out a massive gasp which could be heard in cubicles for
miles around. I've been stuck here for 2 days!

JlR

 

[SusanV]

Glad to hear you got it sorted out - I've been there, beating my head into
the wall for days - it's no fun!

;-)

SusanV