Did I get the field and table names correct? *
I have posted a picture of my database relationships for your
reference because I am not sure which fields your SQL query needs
since it references BOTH tblRecipes and tblRecipeIngredients, and both
tables contain a recipe ID field. It is called "fldRI_RecipeID" in
tblRecipeIngredients and the one in tblRecipes is called
"fldRecipeID." You can view the database table relationships he
http://docs.google.com/View?id=dfrm3z55_15fjbcbvdz
What happens when you open the recordsource query directly as a datasheet? *Does that give an error? *
I did this, and the field in datasheet view contained all 0s.
**BUT**.... then I closed and re-opened the database. This time,
when I opened the form the "Number of Ingredients" textbox results in
#Error, and a separate message box persists that says: "The expression
you entered as a query parameter produced this error: 'Object or class
does not support the set of events'"
I'm assuming that there are in fact child records in tblRecipeIngredients for the records in tblRecipes. *
Yes.
I am not sure why it didn't give the error message at first. Maybe
it is because I had not yet closed and reopened the database????
Jessi