E
evilc via AccessMonster.com
Hello, I am encountering an issue I do not quite know how to solve. I
created a form using the blank form tool. I have 2 calendar control objects
and a subform. The calendar control objects are named dteDate1 and dteDate2.
I use the info selected from these objects to give my query parameters for a
date range. When I run my parameter query it works fine and only asks me to
specifiy the "supervisor" field one time but when I run it on my form it asks
for me to specify the "supervisor" field 3 times before opening the form and
2 more times when I select the start and end date for the query and subform.
The data displays correctly but it should only be asking for the supervisor
field one time.
Here is the code that is in my form:
Private Sub dteDate1_AfterUpdate()
phoneqrysubform.Requery
End Sub
Private Sub dteDate2_AfterUpdate()
phoneqrysubform.Requery
End Sub
Private Sub Form_Load()
Me.dtedate1 = Created - 1
Me.dtedate2 = Created
phoneqrysubform.Requery
End Sub
Any help you could give me on this issue would be greatly appreciated.
Thanks, so much.
created a form using the blank form tool. I have 2 calendar control objects
and a subform. The calendar control objects are named dteDate1 and dteDate2.
I use the info selected from these objects to give my query parameters for a
date range. When I run my parameter query it works fine and only asks me to
specifiy the "supervisor" field one time but when I run it on my form it asks
for me to specify the "supervisor" field 3 times before opening the form and
2 more times when I select the start and end date for the query and subform.
The data displays correctly but it should only be asking for the supervisor
field one time.
Here is the code that is in my form:
Private Sub dteDate1_AfterUpdate()
phoneqrysubform.Requery
End Sub
Private Sub dteDate2_AfterUpdate()
phoneqrysubform.Requery
End Sub
Private Sub Form_Load()
Me.dtedate1 = Created - 1
Me.dtedate2 = Created
phoneqrysubform.Requery
End Sub
Any help you could give me on this issue would be greatly appreciated.
Thanks, so much.