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

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"
<(E-Mail Removed)> wrote in message
news:053A5ABA-6C71-493B-8F1C-(E-Mail Removed)...
> 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????
>

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"
<(E-Mail Removed)> wrote in message
news:053A5ABA-6C71-493B-8F1C-(E-Mail Removed)...
>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????
>