query with parameters

[The_Vicar75]

Hi,

I've got a form in access.

I'd like to, in VBA, count rows in a query between 2 dates (parameters), and put the countings in textboxes on the form.

what's the best way to do so?


Greets,
V.

 

[pbaldy]

Not sure we have enough info to determine the best way, but one way:

Me.TextboxName = DCount( "*", "QueryName", "DateField Between #1/1/08# And #1/31/08#")