requery problem

[David B]

I have a text box on a form header into which a date is entered to filter the
data in the continuous form. A requery in after update does the trick.
If I populate the text box from a calender form then the after update does not
work.
I can fire the requery from the calender form but as I am calling the calender
from more than one form so that is not the answer.

Any thoughts on how do deal with this
TIA
David b

[PC Datasheet]

Put the following code in the click event of a button on your form:

Docmd.OpenForm "NameOfYourCalendarForm",,,,,acDialog
If IsLoaded("NameOfYourCalendarForm") Then
Me!NameOfYourUnboundtextbox =
Forms!NameOfYourCalendarForm!NameOfCalendarControl .Value
Me.Requery
DoCmd.Close acForm, "NameOfYourCalendarForm"
End If

Add code to the calendar so when you select the date, the calendar form becomes
not visible.

Note: You can find the IsLoaded function in the NorthWind sample Db in modules.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David B" <Da***@marleycotenospam.fsnet.co.uk> wrote in message
news:c0**********@news5.svr.pol.co.uk...

I have a text box on a form header into which a date is entered to filter the
data in the continuous form. A requery in after update does the trick.
If I populate the text box from a calender form then the after update does not
work.
I can fire the requery from the calender form but as I am calling the calender
from more than one form so that is not the answer.

Any thoughts on how do deal with this
TIA
David b

[David B]

Got it, Thanks
DB

PC Datasheet <sp**@nospam.spam> wrote in message
news:lj***************@newsread1.news.atl.earthlin k.net...

Put the following code in the click event of a button on your form:

Docmd.OpenForm "NameOfYourCalendarForm",,,,,acDialog
If IsLoaded("NameOfYourCalendarForm") Then
Me!NameOfYourUnboundtextbox =
Forms!NameOfYourCalendarForm!NameOfCalendarControl .Value
Me.Requery
DoCmd.Close acForm, "NameOfYourCalendarForm"
End If

Add code to the calendar so when you select the date, the calendar form becomes not visible.

Note: You can find the IsLoaded function in the NorthWind sample Db in modules.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David B" <Da***@marleycotenospam.fsnet.co.uk> wrote in message
news:c0**********@news5.svr.pol.co.uk...

I have a text box on a form header into which a date is entered to filter the data in the continuous form. A requery in after update does the trick.
If I populate the text box from a calender form then the after update does not work.
I can fire the requery from the calender form but as I am calling the calender from more than one form so that is not the answer.

Any thoughts on how do deal with this
TIA
David b