Rory,
if I used one form, with multipages, how would I call up the specific pages ?
this is how I currently get my unique record number and date...
basically go to last row (that has content) and add 1...
Private Sub UserForm_Initialize()
Dim irow As Long
Dim ws As Worksheet
Me.Width = 340
Set ws = Worksheets("CUSTdb")
'find last row in database
irow = ws.Cells(Rows.Count, 1).End(xlUp).Row
Me.reg1.Value = ws.Cells(irow, 1) + 1
Me.reg2.Value = Format(Date, "mm/dd/yyyy")
End Sub
How do I set a variable to "lock" that record number throughout the userform data collection so that I can just use textbox_record_num.value = xxxx
where xxx is the formula to go get the record that i am actually working on...
so how do I now call
Bookmarks