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

[DLN]

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.

 

[Pieter Linden]

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]

 

[Pieter Linden]

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]

 

[RC]

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.