Current Record in Detail Subform

[ProfK]

In a sub-form for detail lines, I'm trying to respond to the entry of
a bar-code, using the After Update event of the product combobox,
where I set the Product name textbox in the same detail line to the
ProductName value in the combobox. I'm sure I've done this before, and
it only affects the current record, but now when I update the bar-
code, the text the product name textbox in ALL lines gets updated.


Private Sub ddlProduct_AfterUpdate()

txtProductName = ddlProduct.Column(2)

End Sub

 

[Al Campagna]

ProfK,
Sounds like your txtProductName is "unbound" to any field in your table.
If data is entered into such a text control, it will show that value in
every record.
Yout table should have a ProductName text field, and the text control in
your subform should have that indicated as the ControlSource. Then... each
continuous record can "hold" it's own value.
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html