Search Form

[Dave]

I have created a search form that has unbound text boxes to search the
database. There are fields for SSN's, FEIN's and a permit number.
When I search on any of these numbers I get multiple records even
though these records are all unique?

Any pointers will help, I wish I could load the database here.

thanks

 

[Steve]

I have created a search form that has unbound text boxes to search the
database. There are fields for SSN's, FEIN's and  a permit number.
When I search on any of these numbers I get multiple records even
though these records are all unique?

Any pointers will help, I wish I could load the database here.

thanks

Dave,

I recently built an app which searched rego numbers, makes and models
of vehicles. I set the record source of the form to the table, and put
search boxes for the search fields in the form header. I wanted to
dynamically limit the records (enter "a" into the rego box, and
immediately only display those regos beginning with a, enter "b" and
display regos commencing "ab" etc).

I used the keypress event of the textboxes to construct an sql
statement "select * from tblvehicle where [rego]='" & txtrego &"';"
and set the form recordsource to the sql statement, requeried the form
and displayed the new list.

If you want to only return after complete entry, use the afterupdate
event.

Steve

 

[Dave]

I have created a search form that has unbound text boxes to search the
database. There are fields for SSN's, FEIN's and  a permit number.
When I search on any of these numbers I get multiple records even
though these records are all unique?

Any pointers will help, I wish I could load the database here.

thanks

Dave,

I recently built an app which searched rego numbers, makes and models
of vehicles. I set the record source of the form to the table, and put
search boxes for the search fields in the form header. I wanted to
dynamically limit the records (enter "a" into the rego box, and
immediately only display those regos beginning with a, enter "b" and
display regos commencing "ab" etc).

I used the keypress event of the textboxes to construct an sql
statement "select * from tblvehicle where [rego]='" & txtrego &"';"
and set the form recordsource to the sql statement, requeried the form
and displayed the new list.

If you want to only return after complete entry, use the afterupdate
event.

Steve

Thanks will try