Search results

Scratch the "on load" part - I had to put a space between Call and Number... that solved the error but now the control is blank again (event - on load)

I apologize for the ambiguity. The were no error messages. The control was blank even though I changed tables/fields accordingly. As we speak, I just the event to "on load" and I got an error on the FROM clause.

Thank you CJ! Unfortunately it's not working and leaving the control blank. Is there anything else I should look for?

Hi CJ, The recordsource is a table. When I say "autofiltering" I mean I haven't added any combo boxes or searches to the form or subform. Just basically using the subform datasheet as is and when it is filtered, it's filtered through the datasheet's autofilter (by column headers)while...

Yes, exactly. Based on the subform.

Hi, I am a novice and have been searching to no avail for a solution to my problem. I have a main form and a subform (datasheet view) of a table. In my main form I have various calculations which calculates the data from the subform (when auto-filtered). What I am trying to do is count the...