coding help in VBS

[gwward]

I have coded the INSERT Sql command to add records
to an Access database using vbs from a form. I would like to now re-use that form (If Possible) and display it to
allow the user to update his/hers record if the ssn keyed
matches the database.

If you need examples of what I have already done I will
be pleased to supply that information.

Any help would be greatly appreciated.


Thank You

Bill Ward

 

[TallOne]

It sounds like you would just add an update button

Private Sub Update_Click()
cn.Execute "Update tblEmployee set Afield = '" & txtAdata & "', Bfield = '" & txtBdata " Where ssn = '" & txtSSN & "' "
End Sub

Good Luck

 

[johnwm]

VBS questions are best asked in the VBS forum (forum329)

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller