Hi,
I need some code that opens a form on a particular record, then changes one of the fields. I have this so far:
strLink = "[ProjectNo]= '" & Me![ProjectNo] & "' And [EmpNo]= " & Me![EmpNo] & " And [Rev] = " & Me![Rev] & " And [Discipline]= '" & Me.Discipline & "'"
CurrentDb.Execute "UPDATE TblReview SET TblReview.Review = 1 WHERE " & strLink
This code is in the after update event of a field on FrmA. When FrmA is closed it goes to FrmB which shows all the 'reviews'. The field that is updated should show on this FrmB.
At the moment it doesnt seem to be working - I dont get any errors it just doesnt make the change.
Am i missing something? Thank you!
I need some code that opens a form on a particular record, then changes one of the fields. I have this so far:
strLink = "[ProjectNo]= '" & Me![ProjectNo] & "' And [EmpNo]= " & Me![EmpNo] & " And [Rev] = " & Me![Rev] & " And [Discipline]= '" & Me.Discipline & "'"
CurrentDb.Execute "UPDATE TblReview SET TblReview.Review = 1 WHERE " & strLink
This code is in the after update event of a field on FrmA. When FrmA is closed it goes to FrmB which shows all the 'reviews'. The field that is updated should show on this FrmB.
At the moment it doesnt seem to be working - I dont get any errors it just doesnt make the change.
Am i missing something? Thank you!