Enlighten me please...

[BLeslie88]

Trying to carry data from previous record to 'new record' ...

Ways for this...?

Now why do they allow a user to use CTRL ' to copy data down but give no way to the programmer to do it....???

Please enlighten this frustrated soul.

Thanks,
Brian

 

[maikon]

Well, if I understood what do you want...


Sub AddButton()

Dim a, b, c as String

a = TextBox1
b = TextBox2
c = TextBox3

DoCmd.GoToRecord , , acNewRec

TextBox1 = a
TextBox2 = b
TextBox3 = c

End Sub

 

[ghudson]

Dim a, b, c as String

Only the c is dim'd as a string. a & b are variants.

BLeslie88, check this thread out...
http://www.access-programmers.co.uk/forums/showthread.php?t=34732&highlight=duplicate

 

[BLeslie88]

Thank you!

ghudson, that thread, was exactly the remedy I needed!

maikon, thanks for the reply.

Thank you all.