If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Search Form
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 |
#2
|
|||
|
|||
Search Form
On Nov 20, 8:54*am, Dave wrote:
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 |
#3
|
|||
|
|||
Search Form
On Nov 19, 4:48*pm, Steve wrote:
On Nov 20, 8:54*am, Dave wrote: 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 |
Thread Tools | |
Display Modes | |
|
|