By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,396 Members | 1,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,396 IT Pros & Developers. It's quick & easy.

requery after date picker

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a

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 <sc***@no.spam.thedatabaseplace.net> wrote in message
news:g4********************@comcast.com...
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



Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.