Creating A userform to enter data into a database

[john dalton]

i am loking to create a userform that contains the fields

Rec No,

Date

Name

Part Rec1

Part Rec 2

Part Rec 3

Part Rec 4

Part Rec 5

Part Rec 6

Part Rec 7

Part Rec 8

Part Rec 9

Part Rec 10


The form would have a submit changes button and a close form button

as the item codes are entered into the Part Rec fields they would automaically fill in a Part rec Description using vlookup for a datasheet next to these fields would be the amount requisitioned from stock

I am also looking to produce a similar Userform for deliveries and returns - all data would be submitted to a stock movement sheet and therefore the form would need to find the next available line to submit data to

if you require an example please ask

many thanks in advance

john dalton

[Marcol]

An example workbook would be an advantage.

You also might be interested in using Data Forms,
see this link
http://spreadsheets.about.com/od/exc..._data_form.htm

[arthurbr]

Hi,

the data entre form on this site will certainly put you on track

[royUK]

There's also one here

[john dalton]

Here is an example attached of the stock movement sheet that the User Form will feed into - the technicians can take multiple items on the one requisition number.

[royUK]

Why a word document? Attach an example workbook

[john dalton]

here you go please find an attached sheet.

[royUK]

Which sheet are you wanting to write to? Is the userform in the workbook supposed to be used?

[john dalton]

its the worksheet called stock movement, roy