I could use some help here. The code looks right to me, but then again, I'm a noob.
Code:
CurrentDb.Execute "UPDATE tblDMS SET CLIN='" & Me.cboCLIN & "' WHERE [Mission ID]=" & Me.lstMissions.Column(0)
When I click on the button, Command21, I get the following error message:
Run-Time 3075: Syntax error (missing operator) in query expression '[Mission ID]='.
I originally had the field in the table as MissionID, but for S&G I tried with space; problem still exists.
It's probably something simple that I've overlooked (or just don't know enough about), but I can't seem to figure out what the problem with the field is.
I've attached a sample db. The problem happens on 'frmLRC'. Since the table that the listbox points to has only a few records, select or type in 10/26/2014 into the Mission Date field.
What I'm trying to accomplish is to allow an update to the CLIN field on the table by entering the number into the Account Number field on the form, and then clicking on the command21 button.