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
|
|||
|
|||
"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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |