Solved: Passing Value back to userform

[MRichmond]

Good day to you all

I have, what I'm sure is, a simple problem with a userform.

Everything works as it should, a user clicks on add new, and a blank userform is presented. They fill in the required fields (all except the log no), click save and the data is stored on teh hidden worksheet "Data" on teh next empty row.

However, when the user clicks save I would like the Log no to be displayed in the relevate text box.

I'm sure this is probably only one or two lines of code, but it's been driving me mad all day trying to figure it out.

If anyone could help I'd be most grateful.

Sample workbook attached

Thanks in advance for the help

[Bob Phillips]

Add

[vba]

Me.txtLogNo.Text = mcRecord[/vba]

before the save procedure exit.

[MRichmond]

Thanks XLD, as always you are a great resource.