Why is my form asking for the same info 4 times

  • Thread starter evilc via AccessMonster.com
  • Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top