Dear Roger:

Yes, I can see the problem.  The SQL code, when concatenated, reads:

INSERT INTO log ([Admin].[Issue])select [adm_name].[Problem]from
forms!frm_tick_entry

Just because you come to the end of a line in the VBA code does not put a
new-line into the SQL code.  You need to add at least a space at the end of
each line of VBA code when you are between words in SQL.  In this case, it
may be the case you can get away with it, however, as it may work as shown,
since the missing spaces follow a ] in each case, which it may be able to
parse correctly.  But this is a very important habit to obtain.

Place a breakpoint on the line after the line that assigns the SQL string,
and look at the value of the string in a watch or immediate pane.  You'll
see exactly what is going on.  You can paste this into a new query and test
to see it works, or just see what is wrong from how you built it.

The other item is that final reference:

forms!frm_tick_entry

This is a reference to a specific form.  Does a form have a value?  I think
it likely you mean to refer to a specific control on that form, which may
have the value you want to use in this query.  What you change is this:

forms!frm_tick_entry!control_name

I assume the control you wish to reference is on the named form.

Did this help?

Tom Ellison