Access provide the ability to search (actually, filter) by form or
selection. To use those, right-click on the form and chose from the sgortcut
menu. You can also add an unbound combo box to your form, and search from
that. There is a wizard available from the form's Design View (option 3) to
do that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
"Summing multiple fields on a form"
t.com wrote in message
...
I have a form that allows the user to add a new record. Now I want to allow
the user the capability to change a record in the database, when
necessary.
I want to create a search (or filter) on my date field. Do I need to
create
a new form or can I use the same form for adding? Also how do I create
the
search????