Displaying Cell contents in text box on Userform

[duncan beech]

I am currently putting together userform to input records to a data base, adding the new record to the first available row. So far so good. Column A is unique reference field which is currently prenumbered. What I want to do is display the value of this for the current record in a text box on the input userform.

I can't help thinking there is a simple solution but I don't know what it is.

Any help anyone please.

 

[Andrew Poulsom]

Welcome to the Board.

You seem to have determined the number of the next available row, so can't you get the unique reference field from the cell in column A of that row?