View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lars Lars is offline
external usenet poster
 
Posts: 17
Default Adding data to existing data that has a unique number in column

Userform1 adds data to the database as such,
A B C D E F
G
1 PICKID NAME START FINISH PICKS DATE
2 5 TIM 1900
5-19-06
3 7 BILL 2000
5-19-06
4 8 JOE 1900
5-19-06
ETC.

I would like userform2 to add the finish time and picks to the database
that corresponds with the appropriate pickid . the forms are already made
and i've used a combobox in form2 for the pickid , txtbox for finish , txtbox
for picks .
I use to forms because users click a start button wich opens form1 and the
data is entered as seen above, when finished with task they click finish
button wich will open form2 and add the finish time and picks to the database.

I would think this is possible , however finding myself confused on this.
thanks for any help offered.