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

  • Thread starter Thread starter DLN
  • Start date Start date
D

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.
 
DLN said:
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.
Click to expand...

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]
 
DLN said:
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.
Click to expand...

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]
 
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.
 
Back
Top