requery after date picker

[David B]

I am populating an unbound text box from datepicker calender.
After the date has been selected I need the sub form to requery.
If I manualy put a date in the text box the after update works fine however it
does not when the date comes from the date picker form.
Where do I need the requery line in this situation ?
David B
Hexham UK

[Scott McDaniel]

Re: requery after date picker

How are you filling your textbox from the datepicker? You should be able to
issue a .Requery from that code. Assuming your textbox is on the Mainform,
do something like this:

<after your code to fill the listbox>
Forms!NameOfYou rMainForm.NameO fYourSubformCON TROL.Form.Reque ry

Note the "NameOfYourSubf ormCONTROL" ... this is the name of the Control on
your main form that houses your subform, which is not necessarily the name
of the form contained in your subform.

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "


"David B" <david@marleyco tenospam.fsnet. co.uk> wrote in message
news:c057pc$e30 $1@newsg2.svr.p ol.co.uk...[color=blue]
> I am populating an unbound text box from datepicker calender.
> After the date has been selected I need the sub form to requery.
> If I manualy put a date in the text box the after update works fine[/color]
however it[color=blue]
> does not when the date comes from the date picker form.
> Where do I need the requery line in this situation ?
> David B
> Hexham UK
>[/color]

[David B]

Re: requery after date picker


Ok that works, but I am using the same datepicker on more than 1 form, so the
code needs to be on the form that is receiving the date rather than on the
datepicker form.
David B


Scott McDaniel <scott@no.spam. thedatabaseplac e.net> wrote in message
news:g4CdnVVITq Ey1bvd4p2dnA@co mcast.com...[color=blue]
> How are you filling your textbox from the datepicker? You should be able to
> issue a .Requery from that code. Assuming your textbox is on the Mainform,
> do something like this:
>
> <after your code to fill the listbox>
> Forms!NameOfYou rMainForm.NameO fYourSubformCON TROL.Form.Reque ry
>
> Note the "NameOfYourSubf ormCONTROL" ... this is the name of the Control on
> your main form that houses your subform, which is not necessarily the name
> of the form contained in your subform.
>
> --
> Scott McDaniel
> CS Computer Software
> Visual Basic - Access - Sql Server - ASP
>
> "Smash forehead on keyboard to continue ... "
>
>
> "David B" <david@marleyco tenospam.fsnet. co.uk> wrote in message
> news:c057pc$e30 $1@newsg2.svr.p ol.co.uk...[color=green]
> > I am populating an unbound text box from datepicker calender.
> > After the date has been selected I need the sub form to requery.
> > If I manualy put a date in the text box the after update works fine[/color]
> however it[color=green]
> > does not when the date comes from the date picker form.
> > Where do I need the requery line in this situation ?
> > David B
> > Hexham UK
> >[/color]
>
>[/color]