Search Form

[Kat]

Kat
Dec 1, 2:11 pm show options

Newsgroups: microsoft.public.access.forms
From: "Kat" <[email protected]> - Find messages by this author
Date: 1 Dec 2005 12:11:06 -0800
Local: Thurs, Dec 1 2005 2:11 pm
Subject: Search Form
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse

Not even sure this is possible.

I have a table DenialReasons that has 1 field listing reasons. Then I
have the main claims table of denials with 3 fields of which are
DenialReason1, DenialReason2, DenialReason3 that pull off the
DenialReason Table. So anyone person could have 1 or multiple or of
any combination of reasons for each claim record.

I want to create a search form that has a combo box listing denial
reasons from the DenialReason table for user to select from. It then
should search all 3 DenialReason fields for each claim and pull up any
records that have that reason. I have everthing working I just can't
figure out how to make it search all 3 fields for the reason that the
user selects.

Any suggestions would be helpful.

 

[Ron Hinds]

"SELECT * FROM claims_table_name WHERE DenialReason1 = '" & Me!DenialReason
& "' OR DenailReason2 = '" & Me!DenialReason & "' OR DenialReason3 = '" &
Me!DenialReason & "'"

Assuming that DenialReason is the name of the ComboBox.