View Single Post
  #25  
Old June 4th, 2009, 05:35 PM posted to microsoft.public.access.forms,microsoft.public.access.gettingstarted
JessiRight77
external usenet poster
 
Posts: 7
Default Can’t Display Number of SUBFORM Items on MAIN Form... trying to use [RecordCount]

Hurray!!! You are too cool... this fixed the problem with the error
message. And.... it also lets me do a "Filter by Form" search!

One more minor question: Do you know whether there is any way to
specify this textbox as a number field though? When I try to filter
recipes by those with less than 5 ingredients (ie., 5), it also
returns anything more than 9 because it sorts the "1" in the numbers
10, 11, 12, etc. in front of 5. I looked on the "Data" tab of the
textbook, but the only type field I saw was between plain text and
rich text.

Just out of curiosity (to help me understand in the future)... which
part of your query instructed to return ALL records of tblRecipes...
the sole asterisk (*)???

THANKS!!!

Jessi