VBA: Excel form that updates current data or add new data

[jadown]

I built a form called PO Log that contains input text boxes that the user can enter the different iputs that will add an existing row to the worksheet called PO_log. I have the add function working perfectly. But I want to add a function to the form that if the record/data already exist using the PO number as an identifier, to udate the existing record/data rather than adding a completely new row of record/data. Here is the code I have below for the adding function.

Please Login or Register  to view this content.

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

[RSpecianJr]

Hey jadown,

Try putting this in your code:

Please Login or Register  to view this content.

Right above:

'copy the data to the database

If it finds a match for you PONumber within column B, then it will change the iRow row reference to that row. Otherwise iRow remains at the first unused row.

Hope this helps,

Robert Specian Jr.

If you found this helpful please bump my reputation by clicking on the scale in the upper right hand corner of my post.

[jadown]

Thanks but I want the user to be able to add data to that PO# if they need to without the Add button creating an entire new line with the same PO#

[justinp]

Hi jadown,

Did you find the solution to your form?

I've got the same problem with my form, I can add records, but not updated current records.

[royUK]

justinp

Welcome to the Forum, please take the time to read the Forum Rules

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.