Hello, I have a form that has a formula and this text box is hidden and named txtAutoHeld with a formula;
Next im using this formula to save or capture the value to the table in a text box named txtLinearFT which works fine using;
Now the problem is the value changes in the text box txtAutoHeld lets say when I click on a text box named txt1 but the value doesnt change in the textbox txtLinearFT UNLESS I requery the form which I cant because I have validation in the forms before update that uses the controls tags and the ones that are blank it gives a list of controls that are blank. Is there another way to do this?
Thanks,
SoggyCashew.....
Code:
=IIf([cboProductID].[Column](1)="SLOC NOS",Round([cboProductLength].[Column](3)*25/12),IIf([cboProductLength].[Column](3)=1200,1000,IIf([cboProductLength].[Column](3)=300,600,Round([cboProductLength].[Column](3)*50/12))))*[txtCartonsHeld]
Next im using this formula to save or capture the value to the table in a text box named txtLinearFT which works fine using;
Code:
Me.txtLinearFT = Me.txtAutoHeld
Now the problem is the value changes in the text box txtAutoHeld lets say when I click on a text box named txt1 but the value doesnt change in the textbox txtLinearFT UNLESS I requery the form which I cant because I have validation in the forms before update that uses the controls tags and the ones that are blank it gives a list of controls that are blank. Is there another way to do this?
Thanks,
SoggyCashew.....