form and subform

[Azhar]

I have a form that contains a subform. For every value selected i.e order number there is an option in subform to enter details of products that are being purchased. The products are selected using a combo box. I want to display the quantity of the item selected in an unbound text box. Can some one please help.

[pdebaets]

Why do you want the quantity field to be unbound? That seems a bit odd.

Anyway, open your subform in design mode and add a new textbox in the detail section. Name it "quantity". Leave the ControlSource property blank.

[Azhar]

Ok i figured out something....but it doesn't really works the way i want to...
i used the following code

Private Sub Product_id_AfterUpdate()
Dim val As String
 
val = DLookup("Quantity", "Product", "ID = " & [Product_id])

Me.QtyA.Value = val

End Sub

Where "Me" is the form. "QtyA" is the unbound textbox in the form. The problem is that each product i add, it gets the same value.

Please check the attached file.

[pdebaets]

Save yourself some time. Download the customer orders database example: http://office.microsoft.com/en-us/te...in=HA001034557

[Azhar]

I know there are samples available, i just wanted to learn a concept. Thanks anyway.

[pdebaets]

You can learn a lot from reviewing the sample databases.

[Azhar]

Can we do the same thing without VBA, like using expressions...?