Quick question

[Ben]

Hi,

I have a (hopefully) quick question for the experienced...

I have a table of categories. On my form I want certain category values to
bring up a list box of sub-categories, or if there is no corresponding table
of sub-categories to allow text to be entered - but not either/or.

What's the best way to set this up??

regards,

Ben Yamin

 

[Jeff Boyce]

Ben

How will you (or Access) know which categories are supposed to bring up
sub-cats?

An alternate approach is to use a series of combo boxes -- the selection in
the first is used as a criterion in the source of the second. Add code to
the AfterUpdate event of the first to requery the second (whether it's a
listbox or another combo box).

Not sure I understand how you can do one or the other, but NOT do
"either/or"?

Also not clear how a "forms" question relates to the tablesdbdesign
newsgroup?

Good luck

Jeff Boyce
<Access MVP