Printable View
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.
Hope this will work..Code:
'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
-Kayoca Mortation
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]