LittleMan22
Technical User
Hi,
I have a query who's purpose is to 'look-up' all of the currently displayed client's existing policies. It lists these under a continous field (POLICYNUMBER).
What I want to do is pass these values into a single field on the main form of our database. I can get the first policy to pass using DLookUp. However, DLookup cannot work for n+1, etc. So I need some type of code that 'loops' through the existing policies.
I was told that maybe I need to create some type of DAO, ADO code...I don't know where to start with this though. Any ideas?
Ryan.
I have a query who's purpose is to 'look-up' all of the currently displayed client's existing policies. It lists these under a continous field (POLICYNUMBER).
What I want to do is pass these values into a single field on the main form of our database. I can get the first policy to pass using DLookUp. However, DLookup cannot work for n+1, etc. So I need some type of code that 'loops' through the existing policies.
I was told that maybe I need to create some type of DAO, ADO code...I don't know where to start with this though. Any ideas?
Ryan.