Peter,

Not the answer to your question, but have you looked at DataForm, it allows
managing a dataset very easily.

--

HTH

RP

"Peter" wrote in message
...
Hi,

I have a form that adds info to a number of cells in the next free row
of a spreadsheet. (Which works thanks to a number of people who have
helped me here)

I would like to create another form that would be able to select a
particular row (by selecting one a cell in column A by its unique
entry) and having completed the form, add the data to empty cells in
that row by means of a command button.

I can format a combo box to display the unique entries in the cells of
column A, but cannot work out how to get the data written to the
unused cells - grateful for any help/pointers/suggestions.


--
Cheers

Peter

Remove the INVALID to reply