I was wondering if I can get some help with an insert statement I am running in vba.
I need to insert some records based on the current form
my code is something like this:
CurrentDb.Execute "insert into SER_FAXES_FILE ([ID],[STAFF-Resource NAME OT], [ADDRESS UNIQUE ID]) values (SELECT [ID],[STAFF-Resource NAME OT], [ADDRESS UNIQUE ID] from SER_FAXES_FILE_daily where SER_FAXES_FILE.ID = me.id))"
can I do a insert with a select statement with currentdb.execute? its erroriing out
thanks in advance