Another Combo/List box question

[Guest]

I have a table that includes a combo box field called Requirement. The
Requirement field contains 6 choices. I have another field (in the same
table) called Feature. I want to see a list box in the Feature field that
only corresponds to the answer chosen in the Requirements field and I'm stuck
on how to make this happen. Meaning if a select a Requirement of Equipment,
I only want to see the list box of those Features pertaining to Equipment; if
the Requirement is Food, I only want to see the list box of those Features
pertaining to Food, etc. Should I have separate Feature fields for each of
the choices in the Requirement field? Should I develop a query, macro, or
something else?

Thanks in advance.

 

[Jeff Boyce]

Karen

"I have a table ... [with] ... a combo box field."

Eek!

Take a quick scan through the tablesdbdesign newsgroup and catch some of the
reasons why you may decide NOT to use a "lookup" data type field in your
tables.

What you are trying to do inside the table is a little like trying to drive
to Europe ... from Australia -- not even theoretically possible at present.
Access does not have a way, inside tables, to make the contents of one field
dependent on another field (and this might violate some of the tenants of
relational database design). Access tables are a great place to store data,
but lousy for displaying/working with it.

On the other hand, Access forms present an EXCELLENT place to do exactly
what you are describing. If you take a look in the .forms or .formscoding
newsgroups, or at Google.com for "cascading combo boxes", you'll find this a
fairly straightforward bit of work.

Regards

Jeff Boyce
<Access MVP>

 

[Greg T via AccessMonster.com]

Check out the sample "Forms" database at this link:
http://office.microsoft.com/en-us/assistance/HA011201381033.aspx It has a
sample of what you want to do.

 

[Guest]

I was able to synchronize 2 of my tables into a form but I need to
synchronize 1 more table and now I'm having trouble writing the code for the
event procedure - I know very little about writing code and could use some
help.

Thanks.

 

[Jeff Boyce]

Karen

Not sure what you mean when you say "sync ... a table into a form". One
approach to using table data in forms is to first create a query, then use
the query as your source for the form.

Good luck

Jeff Boyce
<Access MVP>