ok this bit of code reads textbox and updates the database but can i do it with out the text boxes using the fields from database in stead
not sure if this should be here or in database section
cheers
Doug
Code:Private Sub Form_Load() With Adodc1.Recordset Do Until Adodc1.Recordset.EOF If Adodc1.Recordset!currant = "Yes" Then txtTotal.Text = Format(Val(txtQuantity.Text) - (Date - CDate(txtFill.Text)) * Val(txtDose.Text), "00") .Update End If .MoveNext Loop .MoveLast End With End Sub




Reply With Quote