Create a Search Box on a form

[Summing multiple fields on a form]

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

 

[Duane Hookom]

If you want to search the form for a specific date, have the user
right-click in the date text box and use the filter for to enter the date.

--
Duane Hookom
MS Access MVP


"Summing multiple fields on a form"

 

[Arvin Meyer [MVP]]

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"