Auto Populate TextBox when choosing from ComboBox.

[FlabbyRoach]

I returned the control source to the correct field in the Process_Sheet table

I changed the after update event in the Operation_ID to:
Me.Operation_Number = Me.Operation_ID.Column(1)

The row source for the Operation_ID is:
SELECT OperationsT.Operation_Description, OperationsT.Operation_Numbers FROM OperationsT;



Should I still have a save button on the sub form?

[FlabbyRoach]

So that did seem to work.
YEAH!!!!!

One more question real quick though.
I have a calculated textbox on the sub form that uses the Time_Each filed multiplied by the SO_Quantity.
Is there a good way to keep the related number to two decimal places?

Thanks for your all help

[pbaldy]

Regarding the save button, I wouldn't bother. The form is bound and will save automatically. Try the Round() function on your calculation to keep it 2 digits.

[FlabbyRoach]

will do
thanks

[pbaldy]

No problemo.

[FlabbyRoach]

pbaldy, where do I put the Round() function if the textbox is a calculated amount?

[pbaldy]

Around the calculation. Like

Round(YourCalculation, 2)

[FlabbyRoach]

Ahhhhhh
Gotcha
I was using the parentheses wrong
I had it as:
Round(MyCalculation, (2))
Thanks again

[pbaldy]

Happy to help!