How do I save or update to a database?

[jalbes]

Let me get right to the point:

-my program starts by filling a combo box with addresses from a database
-when I select an address, I then press "search"
-A new form pops up with all that addreses information. (ie. Tenant name, phone #, Rent cost, etc...)
-all of this works fine until I change a field.

Lets say that John Doe moves out and Bob Smith moves in, I now want to change that in the database. So I search the address, pull up all that addresses information, change the name of the tenant. But how do I save the new information to the database?

here's a copy of the project incase you need to look at it to understand.

Thanx

[HackinCowboy]

You want to do something like this:
rsLeases.Edit
rsLeases("Name") = "Bob Smith"
rsLeases.Update


That should do the trick.
~HC

[doctorgonzo]

If you want to get into SQL (which is far faster than using DAO or ADO for large updates), use something like this (I didn't look at your project, so substitute the correct names):

UPDATE tblResident SET strName = 'Bob Smith' WHERE strAddress = '241 1st St';