Between Query Count!

  • Thread starter Thread starter Fatz
  • Start date Start date
F

Fatz

I have a form that asks for a start date and end date. This form
connects to a between query that pulls the records in the start and
end date time frame. What I need to do is have the time frame form
open...enter the start and end dates...click Submit and have that open
a pop-up form that places the count of the records in the between
query.

So the pop-up form will have a textbox that has a DCount function in
it to return the count of the between query. I have tried this a
bunch of times and everytime the pop-up form opens the text box with
the DCount function returns an error. Any ideas on how to make this
happen?? Any help is MUCH appreciated!!

Thanks,
Chris
 
Hi Fatz,
put a text box on the pop-up form. Let's say you
call it TEXT78. Then in the Open Form event of the form
you could put:
Text78 = Me.RecordsetClone.RecordCount

Substitute your own name for the one in this snippet


Hope This Helps
 
Do the DCount in your main form and then use a message box to display the
results. (or pass the value to your popup form)

Tom
 
Back
Top