Hi all,
I want to look up the value of [A] and return all values of that has that value of [A] against it. However I don't want to define the value of [A] myself each time. I want it to look the value up from existing records and each time I add a new one then display them in a subform/datasheet?
So I could have 5 records where [A] = 5 but all 5 records will have a different value in ( does not allow duplicates). If all 5 records having a subsheet showing all 5 previous entries then that's fine.
How would I go about doing this?
Make any sense at all?
Thanks.
I want to look up the value of [A] and return all values of that has that value of [A] against it. However I don't want to define the value of [A] myself each time. I want it to look the value up from existing records and each time I add a new one then display them in a subform/datasheet?
So I could have 5 records where [A] = 5 but all 5 records will have a different value in ( does not allow duplicates). If all 5 records having a subsheet showing all 5 previous entries then that's fine.
How would I go about doing this?
Make any sense at all?
Thanks.