Prev: Type mismatch
Next: Another Query Question
From: Summing multiple fields on a form on 28 Mar 2010 14:39
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????

From: Duane Hookom on 28 Mar 2010 15:51
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"
<Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in message
news:053A5ABA-6C71-493B-8F1C-071655D78C21(a)microsoft.com...
> 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????
>
From: Arvin Meyer [MVP] on 29 Mar 2010 07:15
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"
<Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in message
news:053A5ABA-6C71-493B-8F1C-071655D78C21(a)microsoft.com...
>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????
>


 | 
Pages: 1
Prev: Type mismatch
Next: Another Query Question