wrote in message
...
I removed the "equal sign" and brackets from the control source of my
textbox, but I still get 0s as a result. So, I have posted a new
picture for clarification -
http://docs.google.com/View?id=dfrm3z55_13c4k47zcx
It shows the property sheets for the main form, the subform, and the
textbox. Did I miss a step?

I don't see anything wrong there, but I may have made a mistake myself
somewhere in my suggested SQL for the recordsource. Did I get the field and
table names correct? What happens when you open the recordsource query
directly as a datasheet? Note: I don't mean opening the form as a
datasheet, but rather clicking the build button (caption "...") next to the
Record Source property to edit the query, and then in the query designer,
flipping into datasheet view. Does that give an error? Does it result in a
0 for the IngredientCount field, for all records?

I'm assuming that there are in fact child records in tblRecipeIngredients
for the records in tblRecipes. If not, of course you would get zeros in the
IngredientCount field.

btw... thank you for the information about my email address. I will
have to figure out how to mask it. When I view these posts I see
only a partial address ), and when viewing the
account settings, Google says it masks the addresses on the web
(although they further state that they are NOT masked when they leave
the web). It won't, however, let me make any changes to the
address, so I'm not sure how you inserted the "NO... SPAM" words in
your email...

You're working through Google Groups? I don't know if/how you can do it
when using their web interface. I use Windows Mail's newsreader function
instead, which lets me set this property.

but that's okay - this is not my normal everyday address

Good; then you won't mind when you have to throw it away.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)