Hi Everyone,

I'am two thirds of the way along with my project but for this one line.
I have 3 dropdown lists where I'am trying to take there selected values and update my database.
My program seems to be getting these values yet they wont go in.

My access database consists of:

tbl_jobs
jobId(autonumber)
job(short Text)


tbl_batch
batchNumber(shortText)
jobId(Number(longInt))
startTime(date/Time)
orignal(number(Int))

I hope my attached pictures below highlight the problem further. Any help on getting this
to work would be amazing. Thanks so much in advance, I really appreciate it.


Name:  problemCode1.jpg
Views: 106
Size:  98.2 KBName:  locals.jpg
Views: 79
Size:  100.0 KB