Is there a way to unbind data from a form during run-
time. On loading the form, the bindcontrol property is
set to false. It then gets sets to true upon the first
action on the form. Customer wants to clear the form
entirely after an action takes place, basically unbind
the data. Going to the end of file won't work because he
wants to search on a combination of six fields.

TIA
Mark

Re: Binding Data by Rush

Rush
Sun Nov 30 10:27:05 CST 2003

Try using parameterized views - you can set one of the parameters to an
impossible value (or add a conditional T/F clause to the view definition)
and requery.

- Rush

"Mark" <anonymous@discussions.microsoft.com> wrote in message
news:062f01c3b750$be2af9a0$a401280a@phx.gbl...
> Is there a way to unbind data from a form during run-
> time. On loading the form, the bindcontrol property is
> set to false. It then gets sets to true upon the first
> action on the form. Customer wants to clear the form
> entirely after an action takes place, basically unbind
> the data. Going to the end of file won't work because he
> wants to search on a combination of six fields.
>
> TIA
> Mark
>
>



Re: Binding Data by Anders

Anders
Sun Nov 30 10:46:16 CST 2003

try

Thisform.SetAll("ControlSource"."")

-Anders

"Mark" <anonymous@discussions.microsoft.com> wrote in message
news:062f01c3b750$be2af9a0$a401280a@phx.gbl...
> Is there a way to unbind data from a form during run-
> time. On loading the form, the bindcontrol property is
> set to false. It then gets sets to true upon the first
> action on the form. Customer wants to clear the form
> entirely after an action takes place, basically unbind
> the data. Going to the end of file won't work because he
> wants to search on a combination of six fields.
>
> TIA
> Mark
>
>