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!NameOfYourMainForm.NameOfYourSubformCONTROL. Form.Requery
Note the "NameOfYourSubformCONTROL" ... 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" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:c0**********@newsg2.svr.pol.co.uk...
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