Iif statements based on two combo boxes

  • Thread starter Thread starter millerwms
  • Start date Start date
M

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
 
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."
 
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

Al Campagna said:
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 said:
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
Click to expand...
Click to expand...
 
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."


millerwms said:
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

Al Campagna said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top