Load lookup value in form to table

[Jacko7289]

Happy New Year good folks,

Need your expertise on this matter.
I've got an ORDER Table which is populated with data from ORDER Form. In my form, a text box looks up for a value (Base cost) in SPECS table. But this lookup value (Base cost) is not saved or loaded unto the ORDER table.
Is there a way to have this value loaded to my ORDER table?

Thanks

[MMcCarthy]

Happy New Year good folks,

Need your expertise on this matter.
I've got an ORDER Table which is populated with data from ORDER Form. In my form, a text box looks up for a value (Base cost) in SPECS table. But this lookup value (Base cost) is not saved or loaded unto the ORDER table.
Is there a way to have this value loaded to my ORDER table?

Thanks

The easiest way is to put an invisible control on the form which is bound to the field where this value is stored. Then put an After Update event on the calculated control to put its value in this new textbox.

Me.NewTextBox = Me.OldTextBox

Mary

[Jacko7289]

Ouch...Did what's suggested but unfortunately nothing shows up on the new text box or the table column itself.

[MMcCarthy]

Ouch...Did what's suggested but unfortunately nothing shows up on the new text box or the table column itself.

Try putting it in the Before Update event instead.

Mary

[Jacko7289]

Suggestion still unsuccesfull.

[MMcCarthy]

Suggestion still unsuccesfull.

Ok try it in the forms On Current event.

Mary