Two Control Sources

[HOTBETZ]

Hey guys

Basically what i am trying to do is get a textbox to save its value in a table.
i have a form in which there is a textbox with a formula in it. i want to save the outcome of this formula to a table.
how do i do it? if i can?
it would be so much easier if textboxes, like comboboxes had a source and a control source.


would be much appreciative of a wise word!

 

[Mile-O]

Why are you wanting to store a calculated value in a table?

 

[HOTBETZ]

i have a table with several prducts.
Products(prod id(PK), contract no, supplier id, order no, etc) and this is filled out using a form.

unfortunatley the order no is not know when the items are put into the table, so i need to find a way of putting the order numbers in without having to fill in each individual record.

i just want to enter an order no for each suppler.

i created a subform run from a query that separates the manufacturers, and i was then able to get all the records related to that manufacturer and contract no to read from a textbox on the form which i had enetered the order no into. (using =[form]![order no] or whatever it is)

the problem i now face is, how to save the table so that each record retains its order no.

hope that helps to fill u in a bit!!