Data Control problem - probably really simple

[_bman_]

i'm not sure about the data control, but when using the ado control, when a change is made in a bound text box, the changes should be automatically made and saved in the database or this may work...not sure tho!

data1.recordset!fieldname = text1.text

good luck

What you can do is. You make a command button on you form and set the caption "Edit" and make a another one with the caption "Update". When the user would like to change the value of you field. he hez to select the edit button and when he want to save the changed value he hez to select the update button. Before you can update the field the data1 control hez to be in the edit mode. or you can not use the update command.

'set your data control in edit mode
Private Sub cmbEdit_Click()
  data1.Recordset.Edit
End Sub

'update the record
Private Sub cmbUpdate_Click()
  data1.Recordset.Update
End Sub

'Make a new record. you dont have te be in edit mode
'to use this command.
Private Sub cmbNew_Click()
  data1.Recordset.AddNew
End Sub

Hope this will work..

-Kayoca Mortation

[Baz673]

hi i'm new to this
i need some help, i'm trying to make a computer program for a car hire firm, and i don't know where to start
i have designed it like a windowz program with the "File" "Edit" "Help" thingz
but i don't know how to set out the rest of it cuz i need to have check lists nd stuff like that

if any1 can help please email me on : [email protected]

thanx alot people

[Edited by Baz673 on 03-19-2000 at 10:47 AM]