Re: Connected Filtered Tables/Combo Boxes...

Hi Evi

Thanks for replying but as a novice this is gobbledygook to me, I was lost
when you started talking about a foreign key!

Basically I have three tables: called Risk (Pick List) text only, Domain
(Pick List) text only and Main Info ***.

The Domain (Pick List) consist of the following

Domain

SDR
CR
OR

The Risk (Pick List) consists of the following columns:

Category Domain

Fire Advice SDR
Security Advice SDR
Social CR
Political CR
Technical Advice SDR
Environmental CR

The Main Info *** gathers all the information entered from the Input Risk
Form and it's on this form that I have combo boxes that read from the pick
lists. This is where I need it to filter so that if you pick SDR only those
with the domain SDR will show.

Hopefully this is a bit clearer, It's hard to explain yourself when you're
not sure of the Access terminology.

Thanks for your help.

"Evi" wrote:

Assuming that your Risk Table has a foreign key link from the Domain table
(I'll call it DomainID)
Call the combo
cboRisk and cboDomain
cboDomain has the fields DomainID (hidden) and Domain
We'll call the form YourForm
Open Properties in the form's Design View
in the After Update Event of cboDomain put

Me.cboRisk.Requery

Click next to RowSource of cboRisk to open the query on which it is based.
In the criteria row under DomainID put

[Forms].[YourForm].[cboDomain]

Please say if any of this is gobbledygook to you. It will help if you give
me the name of your form, the name of the field you want to filter by
(stating if it is text or number) and the name of your combo

Evi






"Cathy" <Cathy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:63A333A8-272E-45CC-99F8-A0FB23A7F860@xxxxxxxxxxxxxxxx
Help, I'm stuck.

How do get a combo box on a form to filter information. Let me explain.
I'm
creating a 'Risk' Database and need to break a list of risks into domains.
There are three domains: SDR, CR & OR which all have a list of potential
risks attached to them. I need the form to be able to sort them into their
individual domains, for instance when someone clicks on the Domain combo
box
they get the above three options, when they choose one of these I then
need
the 'Risk' combo box to only show the risk descriptions allocated to that
domain.

Example: Fire Advice, Security Advice and Technical Advices come under the
SDR domain, while Social, Environmental and Political come under the CR
domain, (at the moment they are all on the same table with their
individual
domain codes next to them in a separate column), so when someone chooses a
CR
domain they only see the Social, Environmental & Political risks.

I hope this makes sense to someone, thanks for any help given.





.

Quantcast