Import to 2 tables

[V.P.]

Hi all,
With my frm_Import, I can import a selected file to append into my existing
table tbl_Info(Info_ID (Auto#), field 1, field 2, ... LastModified (data())
successful without LastModified field. How do I trigger that LastModified
field automatically like the autonumber field to fill the date that data are
imported? And I also need to insert those NEW autonumber to a second table
(reference table) tbl_Ref_Categories (Ref_ID(Auto#), Info_ID, Cat_Code) when
the user select a category code from a cboCategory (which have Cat_Code)?

Thanks in Advance