Use MATCH (pickID on Userform2 against the database) to get row number and
then assign Userform2 data to appropriate cells.

in VBA

row=APPLICATION.MATCH(pickid,Data!A:A,0)


pickid= Userform2 textbox for pickID
Data is you database sheet

HTH
"Lars" wrote:

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.