From: fa on
Hello. I am using MS Access 2007. I have a form that is linked to a query. I
am trying to give the user the option of leaving some text boxes blank if
they do not have the infomation. What formula do i use in the query?

Thanks
--
fa
From: John W. Vinson on
On Tue, 27 Apr 2010 11:58:02 -0700, fa <fa(a)discussions.microsoft.com> wrote:

>Hello. I am using MS Access 2007. I have a form that is linked to a query. I
>am trying to give the user the option of leaving some text boxes blank if
>they do not have the infomation. What formula do i use in the query?
>
>Thanks

Add a criterion

OR [Forms]![nameofform]![nameofcontrol] IS NULL

to the other criteria referencing said textbox.
--

John W. Vinson [MVP]
From: Jeanette Cunningham on
The option to leave some text boxes blank is the default behavior of a form.
It doesn't require any formula in the query.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"fa" <fa(a)discussions.microsoft.com> wrote in message
news:B8ACF120-4C1E-4505-82D0-E330F090A83B(a)microsoft.com...
> Hello. I am using MS Access 2007. I have a form that is linked to a query.
> I
> am trying to give the user the option of leaving some text boxes blank if
> they do not have the infomation. What formula do i use in the query?
>
> Thanks
> --
> fa


 | 
Pages: 1
Prev: pop-up that asks a question
Next: Switchboard