Re: Help-How to retreive multiple records from 1 subform to another subform?

On 26 Jul 2006 13:30:03 -0700, "Ramona" <ramona.sidharta@xxxxxxxxx>
wrote:

Hi there,
Im wondering if anybody could help me on this. I have 1 subform
(EditTarget) and 2 nested subforms (EditOrderDetails and
EditProductSubform)within 1 Main Form (EditCustomer). In EditTarget
subform, I have records of "ProductName" along with its
"TargetCapacity" that is associated with each Customers (1-M
relationship). What I would like to do is to somehow retrieve the
"ProductName" records linked to customers into a textbox called
"ProductID" in EditProductSubform. Thus, when I open the EditCustomer
Main Form, it will automatically fill the "ProductID" textbox with
multiple records in Detail sections of EditProductSubform.
I tried to do it by using Dlookup but it only gives me the first value.

I guess, thats because Dlookup will only return single value. Thus, I m
trying to use Recordset. However, my code currently is not working.

Your basic error is assuming that data is stored in Subforms or in
Textboxes. It isn't. It's stored in tables; the form is only a window,
a tool to let you view data.

If - and I REALLY have to question the validty of this entire
operation!!! - you want to copy multiple detail records, an Append
query into the table upon which the Product Subform is based would be
the appropriate technique.

John W. Vinson[MVP]
.

Relevant Pages