diff values in unbound field on diff continuous form rows

[thewiseguy]

hi there,

in a contiunous form i have the following fields:

cmbstockitem - bound to list of 5
txtrequestedamount - a number field represently quantity to be ordered
autostockunit - unbound but automatically set to the appropriate unit as soon as cmbstockitem has been selected (eg litres, kg etc)

the trouble is with the last field. if the user goes onto a new row of the form and selects a different stock item, every single one of the autostockunit fields will change, instead of just that row. is there a way of maintaining the unit in the above row but still allow a different unit in the row below?

hope that makes sense.
cheers.

 

[RichO]

No, I don't believe you can do this with unbound controls. You would need to add a field to your table.

 

[thewiseguy]

You would need to add a field to your table.

cheers RichO - i'll try it out first thing tomorrow