G
Gaetanm via AccessMonster.com
I'm having a problem I can't see the trees from the forest.
In the following SQL I added on the Job Sheet [Customer Name] and Me.
[txtcompanyname]
The SQL was working fine before the modification. It's proberbly very obvious
to someone
out there. I have been looking but just can't see it. Help
SQLstrg = "INSERT INTO [Job Sheet] ([CustomerID],[Customer Name],[Start Date],
[Notes])" & "VALUES(" & Me.[cboCustomer] & ", #" Me.[txtcompanyname] & "# ,"
& Chr(34)& Me.[txtDate] & "# ," & Chr(34) & Me.txtJobDescription & Chr(34) &
")"
Gaetanm
In the following SQL I added on the Job Sheet [Customer Name] and Me.
[txtcompanyname]
The SQL was working fine before the modification. It's proberbly very obvious
to someone
out there. I have been looking but just can't see it. Help
SQLstrg = "INSERT INTO [Job Sheet] ([CustomerID],[Customer Name],[Start Date],
[Notes])" & "VALUES(" & Me.[cboCustomer] & ", #" Me.[txtcompanyname] & "# ,"
& Chr(34)& Me.[txtDate] & "# ," & Chr(34) & Me.txtJobDescription & Chr(34) &
")"
Gaetanm