Allen Browne Search

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
 
A

Allen Browne

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

Jan Baird

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
J

Jan Baird

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top