By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,499 Members | 829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,499 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
DLN <dl*@dln.invalid> wrote in message news:<Xn**************************@216.196.97.131> ...
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]
Nov 13 '05 #2

P: n/a
DLN <dl*@dln.invalid> wrote in message news:<Xn**************************@216.196.97.131> ...
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]
Nov 13 '05 #3

P: n/a
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.

DLN <dl*@dln.invalid> wrote in message news:<Xn**************************@216.196.97.131> ...
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.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.