Hello All,
I have built a form that has a subform and they are linked by RECNO. The subform can have one or multiple entries. I am trying to calculate a field that will pull all of the entries into it, not just one. I have figured out how to successfully pull the first record that matches into it, but I cannot figure out how to pull the rest of them. I know that this would typically probably need a loop of some sort, but I am not familiar with VBA and I cannot figure out how to do this in access.
In the photo I have attached, it shows my field I am trying to enter this in at the bottom, I have got the first one in there, but how do I get the additional ones? The recno is equal on all three of these.
Can anyone help?