Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Syntax Missing Operator
- Thread starter primagic
- Start date
best way to debug this is always do
dim strSql as string
strSql = "insert into db
utcomeChanges (LeadID, OutcomeID, EmployeeID ) values (" & Me.LeadID & ", " & Me.OutcomeID.Column(1) & ", " & Forms!frmLeads!LoggedInAs & ");"
debug.print strSql
'now look at it. Post the results if necessary
...
docmd.runsql strSql
dim strSql as string
strSql = "insert into db
utcomeChanges (LeadID, OutcomeID, EmployeeID ) values (" & Me.LeadID & ", " & Me.OutcomeID.Column(1) & ", " & Forms!frmLeads!LoggedInAs & ");"debug.print strSql
'now look at it. Post the results if necessary
...
docmd.runsql strSql
- Status
Similar threads
- Locked
- Question
- Locked
- Question