[AccessD] Can I do this?

[Tina Norris Fields]

I'm making a database for a local law firm.  They have in place a paper 
system that is complex, but, it works.  They are sort of ready to switch 
to an electronic system, but, it has to look just like the paper system 
already in place.  Once they know they can trust an electronic system, 
they'll allow remodeling to simplify.  That's the situation.  I'm 
working on a particular part of the system now, and could use some help.

A new file number is created from a six-digit sequential number, a dash, 
a two-digit number for the month, a dash, and a two-digit number for the 
year, resulting in numbers (short text) such as this:  011456-05-15.

I've made a form that has unbound controls for crafting the number.
A textbox txtMaxSeqNo displays the value DMax("File_SeqNo","tblFiles") 
as a starting point.
A button btnMakeNext runs the Event Procedure:
Private Sub btnMakeNext_Click()
     TF_number.Value = Format(Int(txtMaxFileSeqNo) + 1, "000000")
     TF_month.Value = Left(CStr(Date), 2)
     TF_year.Value = Right(CStr(Date), 2)
     TF_Date.Value = Date
End Sub

I want to add these values as a new record to the existing tblFiles.  
Can I make a temp table from these values, append them to the real 
table, and delete the temp table?  Can I craft a query from these 
unbound control values and use it to make a temp table, or to append 
directly to the real table?  I'm not seeing how to capture the values 
from this form and put them eventually into the the real table.

Ultimately, of course, all this will be behind the scenes, attached to a 
click event, but, while I'm building it, I want to see each step succeed 
before moving on.

I'll appreciate ideas.

TNF

-- 
Tina Norris Fields
tinanfields-at-torchlake-dot-com
231-322-2787