Allen Browne Search

  • Thread starter Thread starter pfm721
  • Start date Start date
P

pfm721

I have modified the Allen Browne search form to filter the results of a
parameter query. The query gets its paramters from some of the fields on the
search form. It works but only if I type in the Locality parameter. For
Example:

User Enters

5 digit code in txtFilterCPTCode
Selects State from cboFilterState
Selects County from cboFilterLocality

The query uses the input from those three boxes as the paramters.
The query works great. However after entering a value in those three places,
when you select the filter button on the form I get a Dialog box that pops up
asking me to enter a parameter value for Locality. I can't figure out why it
is doing this as I selected it in my last combo box. If I enter the Locality
by hand in the box the form works. If I click cancel it asks me to Debug and
takes me to Me.Filter = strWhere which is highlighted.

The immediate window has this in it:

([HCPCS Code] = "45378") AND ([State] = "GA") AND ([Locality] = "Albany")

Looking at that it looks like it should have worked.

Thanks in Advance
 
If your HCPCS Code field is a Number field (not a Text field), remove the
quote marks from around the value, i.e. generate:
([HCPCS Code] = 45378) AND ...

If is is a text field, it looks right. Mock up a query to see if there are
any results.
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Back
Top