Editing cell value in txtbox + updating that cell value in database..going MAD!!

Hey,

New to all this but here's where I'm at:

I have a combobox which pulls up from a database a list of 100 stores. On change, (selection of store), my database info from the row corresponding to that store fills in 10+ text boxes. THE PROBLEM, I can edit a textbox value , but how do I save this one specific value in my database. How does this new cell value replace the old one. Code is as follows, I know it's dirty and the long way of doing it..but at this point, I would just like to figure out how to replace new cell value in userform into corresponding cell in database...

Thanks for any input!!
Matt

Please Login or Register  to view this content.

Cheers...

Attach to a biutton on the form after the textboxes have been updated:

Please Login or Register  to view this content.

Hey Corey, thanks..will try now and let you know..I add this code to the Update_Button I presume...

Hey Corey, Thanks again....So i pasted the code in the button as shown below. Good news is im not getting any errors when the macro runs however no changes pop up anywhere in the database...any ideas as to where this info could be going, if anywhere! cheers again!

Please Login or Register  to view this content.

Try placing a (') to the left of the line> On Error Resume Next
It should highlight a line for you

Just proof read the code.

Change the

Please Login or Register  to view this content.

to :

Please Login or Register  to view this content.

Hey Corey,
I've made those changes however now i'm getting a run time error of object not found in the line below:

rngFound.Offset(, 1).Text = FrmExistingClient.txtTaxId.Text

On the left side of equal, for rng value, i'm getting .Text="" . However on the other side for the Frm Value I'm getting the amended cell value. So it's showing up in the code, just not making it to the database...Why do you think this is, and where is this object not found error coming from as in this line seems proper to me

Thanks ...

**object required , and not object not found

Can you try changing all the .Text to .Value instead to see if that works.

You need to remove the (') from in front of the On Erroe line again also.

That was it my man!!!! Just had to change all of them and it worked like a charm! I wish I had met you 18 hours ago !! Thanks a lot buddy! Was about to start hardcoding everything otherwise!!