A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Searching with a text box



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 05:51 PM posted to microsoft.public.access.forms
Srenfro
external usenet poster
 
Posts: 26
Default Searching with a text box

Hello I am trying to creat a search option in my database where when I want
to find customers by city all i have to do is type in the city in the text
box and search and all the results show up in the bottom datasheet subform so
far i have the text box and the subform and all the records but when i try to
do a search it acts like i hit tab and just goes to the record right under or
next to the record and it also show all my records not the ones i was trying
to search. is there a way i can get this text box to search and only bring
the results i want to show up in the subform thank you in advance
  #2  
Old April 23rd, 2010, 06:16 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Searching with a text box

i have the text box and the subform and all the records
I would use a combo to select city rather than typing (fumble fingers
typing) to be used as criteria in a query. Have event requery after
selection.

--
Build a little, test a little.


"Srenfro" wrote:

Hello I am trying to creat a search option in my database where when I want
to find customers by city all i have to do is type in the city in the text
box and search and all the results show up in the bottom datasheet subform so
far i have the text box and the subform and all the records but when i try to
do a search it acts like i hit tab and just goes to the record right under or
next to the record and it also show all my records not the ones i was trying
to search. is there a way i can get this text box to search and only bring
the results i want to show up in the subform thank you in advance

  #3  
Old April 23rd, 2010, 07:47 PM posted to microsoft.public.access.forms
Srenfro
external usenet poster
 
Posts: 26
Default Searching with a text box

I have tryed that to but I get the same results thats why i thought a text
box would be the object to use. I tryed to use the find as you type idea and
it just erases and rewrites the current record am i missing something mabey?
I will try again though and let you know what happens thanks
"KARL DEWEY" wrotie:

i have the text box and the subform and all the records

I would use a combo to select city rather than typing (fumble fingers
typing) to be used as criteria in a query. Have event requery after
selection.

--
Build a little, test a little.


"Srenfro" wrote:

Hello I am trying to creat a search option in my database where when I want
to find customers by city all i have to do is type in the city in the text
box and search and all the results show up in the bottom datasheet subform so
far i have the text box and the subform and all the records but when i try to
do a search it acts like i hit tab and just goes to the record right under or
next to the record and it also show all my records not the ones i was trying
to search. is there a way i can get this text box to search and only bring
the results i want to show up in the subform thank you in advance

  #4  
Old April 24th, 2010, 12:17 AM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Searching with a text box

it just erases and rewrites the current record am i missing something mabey?
Somehow you misinterpreted what I proposed.

Use a combo in the form header to select your city from the city table or
totals query from your data table to provide a list of existing cities to
pick from.

Then have a subform fed by a query that uses the combo box as criteria on
the city field. In query design view put this in the Criteria row under the
city field, substituting your form and field names --
[Forms]![YourFormName]![ComboName]

Then use an event of the combo OnChange to requery.

Doing this will not erase any data.

--
Build a little, test a little.


"Srenfro" wrote:

I have tryed that to but I get the same results thats why i thought a text
box would be the object to use. I tryed to use the find as you type idea and
it just erases and rewrites the current record am i missing something mabey?
I will try again though and let you know what happens thanks
"KARL DEWEY" wrotie:

i have the text box and the subform and all the records

I would use a combo to select city rather than typing (fumble fingers
typing) to be used as criteria in a query. Have event requery after
selection.

--
Build a little, test a little.


"Srenfro" wrote:

Hello I am trying to creat a search option in my database where when I want
to find customers by city all i have to do is type in the city in the text
box and search and all the results show up in the bottom datasheet subform so
far i have the text box and the subform and all the records but when i try to
do a search it acts like i hit tab and just goes to the record right under or
next to the record and it also show all my records not the ones i was trying
to search. is there a way i can get this text box to search and only bring
the results i want to show up in the subform thank you in advance

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.