Dlookup

[TobyMace]

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.

 

[Minty]

Not clear at all.
Can you make up a picture if this is for a form and/or better still some sample data.
Please include
A) Source data, enough to cover all eventualities.
B) What you expect to see as a query result.

 

[The_Doc_Man]

A SELECT query would do this if everything is in the same table.

The question would be how you select [A], and there is where your description becomes very vague. That would be critical to the process, so I'm with Minty. We need to know at least a little bit more than you gave us.

 

[TobyMace]

Hi guys,

Thanks for help. I was able to find a solution myself over the weekend.
Apologies for wasting your time!

Kind regards.