update database using web form.

[qwer]

Basically, I'm doing a project on car park fees, where we use SMS to pay for the duration that the car is parked in the car park.

So, our system requires the car park user to register his/her particulars into the web form. However, if there is a change in his particulars, he/she will have to update it on the web form. At the same time, the database will save that record but how do I do that?

Thank you for taking the time to read this post. =)

[jhardman]

Basically, I'm doing a project on car park fees, where we use SMS to pay for the duration that the car is parked in the car park.

So, our system requires the car park user to register his/her particulars into the web form. However, if there is a change in his particulars, he/she will have to update it on the web form. At the same time, the database will save that record but how do I do that?

Thank you for taking the time to read this post. =)

How do you add new records? If you use a recordset and use the addnew() method, then editing a record is exactly the same, you would just skip the "addnew" line. If you use an "insert" SQL statement to add new records, then the most similar method for editing is ... just a moment, the word eludes me. No, I don't remember. Tell me if you need it, and I will look it up, otherwise stick with the recordset.

Jared