HelpJess:
Lookup wizards are not available for creating a subform.
There is a control wizard, and that will create the subform based on either an existing form, a table, or a query. If you have based the subform
directly on either a table or query then this complicates things; however, if you have used another form, then what I have suggested will work.
++ There is a look-up
field wizard, that creates either a lookupfield or a multivalue field
in the table - this is
not a subform and is what I am suspecting is the root of your quandary based on your two posts.
I am not so certain there is a way to obtain the count of related records in such a field... something we'll have to dig in to deeper...
>> However, as NeoPa has pointed out, you need to clarify what you have done here so that we have a better idea as to which direction to go.
BTW:
Lookup fields are really only valuable for SharePoint destined applications, in all other cases (
IMNSHO) it should be avoided like the plague...
The Evils of Lookup Fields in Tables
Lookup fields hide from the user what a properly normalized database should be doing...
Database Normalization and Table Structures
LUF/MVF are well intentioned; however, nightmarish to handle in queries and in VBA.... let alone in a calculated control.