save in table a '=[field].column(2)' data?

[keiserc]

I don't know the proper name for it - but I have a field which automatically displays related data in a field. =[field].column(2) it works just fine.

only I need the data (only one digit) to actually be saved in the table. presently it 'looks up-from the lookup table' and 'displays' but does not save into the table. How can I get it to save? I need the variable for search functions.

 

[KenReay]

Hi

Leaving aside the usual advise about not saving calculated data in a table becuase it breaks the rules of normalisation

in the form, have the column from the table bound to a text box, with visible property set to false

in the before update event of the form put MyTExtBox = MyCombo.Column(2)

to pick out one character from the string, see the mid() function

so, something like MyTExtBox = Mid(MyCombo.Column(2),3,1)



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK