Recording Text Box value to Table

[jtmm]

I have a data entry form with a text box that is formatted with "=Format(Date() ,"yymmdd") & Format([ID])" where ID = AutoNumber field in my table.

I am using the text box value to view/create new sample records as follows 140308001, 140308002... for samples entered on the same day.

Currently my table is only recording the Format(Date()," yymmdd") portion of the sample ID when I use the following code:

DoCmd.GoToRecor d acDataForm, "frmGenerat e", acNewRec
Me.VoucherNo.Va lue = Me.AutoDate.Val ue

Can I capture multiple format values in a text box on my table?

[GKJR]

=Format(Date(),"yymmdd") & Format([ID])

You're not giving the format function an argument in the second half. Furthermore, you can't concatenate a number to a string. Look into CStr() function.

http://msdn.microsoft.com/en-us/library/0zk841e9%28v=vs.84%29.aspx