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

requery problem

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

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


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

Nov 12 '05 #2

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



Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.