By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,081 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,081 IT Pros & Developers. It's quick & easy.

Load lookup value in form to table

P: 10
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
Jan 3 '07 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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.

Expand|Select|Wrap|Line Numbers
  1. Me.NewTextBox = Me.OldTextBox
Mary
Jan 3 '07 #2

P: 10
Ouch...Did what's suggested but unfortunately nothing shows up on the new text box or the table column itself.
Jan 3 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 3 '07 #4

P: 10
Suggestion still unsuccesfull.
Jan 4 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
Suggestion still unsuccesfull.
Ok try it in the forms On Current event.

Mary
Jan 5 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.