Updating field in datasheet form row by row on click

[N1212]

Hi,

I have a large inventory list where user should use a datasheet form with search boxes to find particular items.
Then, depending on the item type and other things, user need to click on one of the text boxes in the datasheet form to create a unique description of the item.
So, for example:
I have filtered a group of 10 items,
I click on the item name field and this should create a new description in a new field in the same row based on the item name and several other fields.
I can not use update query for this because each new description is also dependent on specific user knowledge of the item and how it was manufactured.

In short, I have something like this on click event of the item_name box:
custom_description.Value= item_name.value&" "description.value&" "&manufacturing_details.value

It works but custom_description boxes in all 10 rows get the same value of the clicked row.

How do I update just one row at a time?

Thanks

 

[vbajock]

That usually happens if your field is not bound to a data field in the underlying table. Check your control source property.