Thanks Gord

I did download the file PartLocDB ,. It was almost what I wanted, with the
exception, that it obviously did not pick up any data already in the data
base and created a new record - thats the tweek I would be looking for. (not
that i am saying it is an easy tweek!)

Thanks again

Brian

Gord Dibben wrote:
What you found at that site is instructions for creating and using a
UserForm.

I could never aspire to providing more help than Debra has given at that
site.

Did you download either of the the sample workbooks?

Modifications will be made depending upon your requirements for different
labels and linked cells.

You may be better off simply using the built-in Data Form Excel provides.

See Debra's site for instructions and a link to John Walkenbach's Enhanced
Data Form.

http://www.contextures.on.ca/xlDataEntry01.html#List

Gord

Hi Gord, thanks for the response

[quoted text clipped - 26 lines]
I have followed the threats on how to create a form, but will require it
modified slightly. (g).

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200911/1