Add data to row that already contains data [Solved]

- - Latest reply:  aileen - Mar 1, 2019 at 01:19 PM
I want to enter data for the same product but it needs to be done on different days, with two different entry forms, so the row will already contain data points and I will have to pick the row and add more data in the following cells of the same row (not a new one)

example:
on day 1 I enter: on day 2 I add on to the same row

Day Product Weekday processing date amount operator


Is there any way that vb can find the row with the product I need and then just add data into the same row with a second entry form?
See more 

1 reply

Posts
13034
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1537
0
Thank you
WOw, you are re-inventing the database!

Why not have a DB with an entry form, for entering. Then another form for management of already entered parts? If you have no experience with a DB, the learning curve is way less sharp as with VB. Besides, a DB can scale!

If you decide to go down this route, I will help with design. Otherwise, wait around, and more than likely someone else will author you a script to cut and paste.
Thanks! I guess this will be the route I'll ultimately go as there is a huge database already in place.
But thanks for your idea!
Respond to ac3mark