How do I set up and "either/or" query parameter?

[PATRICKPBME]

I have a button on my form that lets me generate a report on a contact for a physician by typing in the physician name when prompted. Some physicians have more than one contract so I want to have the option of either entering the name or the contract number.



Currently, the query has the criterion of [Enter Name] when it is run. I thought if I entered [Enter Contract # - Optional] in the contract field on the "or" line this would allow me to search either way. I have tried putting the parameters on different lines but as yet have not found the right combination, assuming this can be done.

I am also looking into how a drop down box might be incorporated for a search as that would alleviate the need for several different buttons. That option remains on the upward side of my learning curve.

Thanks in advance.

[ranman256]

in a continuous form youd have it show all physician and contracts.
in the form header put 2 unbound combo boxes: cboDr, cboContract
the user can do 1 or the other or both. (tho you dont need Dr, if you have Contract)

but a FIND button on the header too, then the CLICK event of this button will filter the data:

'----------------
sub btnFilter_click()
'----------------
dim sWhere as string 

sWhere = "1=1"
if not IsNUll(cboDr) then sWhere = sWhere & " and [phsician]='" & cboDr & "'"
if not IsNUll(cboContract) then sWhere = sWhere & " and [Contract]='" & cboContract & "'"

If sWhere = "1=1" Then
  Me.FilterOn = False
Else
  Me.Filter = sWhere
  Me.FilterOn = True
End If
end sub

[PATRICKPBME]

Thank you!!!