Iif statements based on two combo boxes

[millerwms]

I am trying to create a rule where depending on what is selected in the
[Issue] field, only certain values from my value list are available in my
[Issue Type] field.

Meaning, I have 16 values in [Issue] and rougly 30 values in Issue type,
only a handful of which will be visible as a choice. I think it should look
something like this:

If [Issue]="Dental",[IssueType]="Eligibility";"Claims"

Not sure if this is right, and I am also missing a value if false.

Any help or assistance is GREATLY appreciated!

Thanks,
Scott

 

[Al Campagna]

millerwms,
On my website below, I have a 97 and 2003 sample file called Synched
Combos.
It demonstrates how to use the value of combo1 to filter the selections
avaialable in combo2.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[millerwms]

Thanks for the suggestion Al, I appreciate it. When I opened the database,
the cities options did not change when the state changed.

Thanks,
Scott

millerwms,
On my website below, I have a 97 and 2003 sample file called Synched
Combos.
It demonstrates how to use the value of combo1 to filter the selections
avaialable in combo2.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

I am trying to create a rule where depending on what is selected in the
[Issue] field, only certain values from my value list are available in my
[Issue Type] field.

Meaning, I have 16 values in [Issue] and rougly 30 values in Issue type,
only a handful of which will be visible as a choice. I think it should
look
something like this:

If [Issue]="Dental",[IssueType]="Eligibility";"Claims"

Not sure if this is right, and I am also missing a value if false.

Any help or assistance is GREATLY appreciated!

Thanks,
Scott

 

[Al Campagna]

millerwms,
Which version?
I downloaded and tested both the Access 97 and the Access 2003 versions
of Synched Combos.
Both versions worked properly.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Thanks for the suggestion Al, I appreciate it. When I opened the
database,
the cities options did not change when the state changed.

Thanks,
Scott

millerwms,
On my website below, I have a 97 and 2003 sample file called Synched
Combos.
It demonstrates how to use the value of combo1 to filter the
selections
avaialable in combo2.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

I am trying to create a rule where depending on what is selected in the
[Issue] field, only certain values from my value list are available in
my
[Issue Type] field.

Meaning, I have 16 values in [Issue] and rougly 30 values in Issue
type,
only a handful of which will be visible as a choice. I think it should
look
something like this:

If [Issue]="Dental",[IssueType]="Eligibility";"Claims"

Not sure if this is right, and I am also missing a value if false.

Any help or assistance is GREATLY appreciated!

Thanks,
Scott