I would like to get the record count from another table to display on a form. With =Count(PhotoTBL.PhotoID) it at least doesn't refuse the syntax, but it displays as #error. I have tried it with the primary key (ID) and with a different field. Can I do this?
I got this syntax from an example, but it isn't working. It accepts the syntax, but doesn't display either an error or a value. DCount("PhotoID", "PhotoTBL")
Kevin Robertson
@Reply 3 years ago
Are you entering the function in the Control Source of the Text Box?
Try this to count all the records in the table:
=DCount("*", "PhotoTBL")
Joan YoungOP
@Reply 3 years ago
Yes, putting in control source. That did it! These courses are the best! 18 years ago, I really knew what I was doing with Access, but I've forgotten SO much. Thank you.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 3.
