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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"find" form: enter text, click button, show results?



 
 
Thread Tools Display Modes
  #1  
Old August 31st, 2004, 05:17 AM
DLN
external usenet poster
 
Posts: n/a
Default "find" form: enter text, click button, show results?

I want to create a form page that has a single field on it, say "last
name", and when that last name is entered in, I want to click a button and
have it bring up another page with the results. Any idea how to do this?

Thanks.
  #2  
Old August 31st, 2004, 01:44 PM
Pieter Linden
external usenet poster
 
Posts: n/a
Default

DLN wrote in message ...
I want to create a form page that has a single field on it, say "last
name", and when that last name is entered in, I want to click a button and
have it bring up another page with the results. Any idea how to do this?

Thanks.


create an unbound form.
put a textbox on it.
create a query that gets its criteria from the textbox.

SELECT...
FROM...
WHERE SomeField=Forms![MyForm]![MySearchValue]
  #3  
Old August 31st, 2004, 01:44 PM
Pieter Linden
external usenet poster
 
Posts: n/a
Default

DLN wrote in message ...
I want to create a form page that has a single field on it, say "last
name", and when that last name is entered in, I want to click a button and
have it bring up another page with the results. Any idea how to do this?

Thanks.


create an unbound form.
put a textbox on it.
create a query that gets its criteria from the textbox.

SELECT...
FROM...
WHERE SomeField=Forms![MyForm]![MySearchValue]
  #4  
Old August 31st, 2004, 02:35 PM
RC
external usenet poster
 
Posts: n/a
Default

Go to the form you are working with. View the form in Design mode.
Check the Data tab and set the source to the table where the last
names are. In the toolbars at the top, find the little icon that
shows the Fields list, click it. This will bring up a list of the
fields in the table. Drag and drop the last name field to your form.

DLN wrote in message ...
I want to create a form page that has a single field on it, say "last
name", and when that last name is entered in, I want to click a button and
have it bring up another page with the results. Any idea how to do this?

Thanks.

 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
dlookup miaplacidus Using Forms 9 August 5th, 2004 09:16 PM
Hide or show Control Button on Form in Access 97 Pete Sperling Using Forms 8 July 13th, 2004 04:13 PM
auto entry into second table after update Tony New Users 13 July 9th, 2004 10:42 PM
find keywords Tennessee picker General Discussion 1 July 7th, 2004 06:23 AM
how to show fields when u click a button mimi General Discussion 1 June 23rd, 2004 09:47 AM


All times are GMT +1. The time now is 12:53 AM.


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