Record count help

[imz]

I am trying to count the records of a query result and place the answer into a textbox on a form. I have found the DCount function in the help files and tried the following code:

= DCount("[MonthlyFeeID]", "Monthly Fees Query")

I keep getting an error about placing something before the equals sign, but I don't know what to put there.

Thanks

[Rabbit]

I am trying to count the records of a query result and place the answer into a textbox on a form. I have found the DCount function in the help files and tried the following code:

= DCount("[MonthlyFeeID]", "Monthly Fees Query")

I keep getting an error about placing something before the equals sign, but I don't know what to put there.

Thanks

Put this in the control source of the text box:

=DCount("*", "[Montly Fees Query]")

[imz]

Doesn't work, it gives me an error message in the textbox.

[Rabbit]

What's the error?

[imz]

There is an "#Error" message that appears inside the textbox when I open it on form view. I should mention that there are no fields on my form, so i'm guessing that's why your method does not work.

I'm trying to make the record count appear on the main menu screen and unless I put the query fields on the form I think they won't work. I don't want to do that because I want another record count and I can't put 2 different query fields on one form without therefore being a subform. For this reason i thought using Dcount in VBA would be the answer.

[Rabbit]

You don't need the table bound to the form for DCount to work. It should work.

Edit: I just noticed that I had a typo in my code. I spelled Monthly wrong. Fix that and see if it works.

[imz]

It works! Thanks for the help.

[Rabbit]

Not a problem, glad to help.