Help with updateing chk box in tbl

C

Chad

Hello, I have a continuous form named "frmUpdateEmployees" which I need to
update employee information like name, date of hire and employment status. On
this form I have a chk box named "chkStatus" and if checked I want it to
update a table named "tbl_PerformanceReviewMain". The problem im having is
the table "tbl_PerformanceReviewMain" is information saved from another form
but has a field named Status. this is the field I want my "chkStatus" to
update. How could I do this? Thanks!
 
K

Klatuu

Don't confuse forms with data. All data is housed in tables. Forms are only
a way to view and manipulate the data.

Create an Update query that updates the field for the current employee and
execute it in the After Update event of the Check box on the form.

It would be something like:

strSQL = "UPDATE tbl_PerformanceReviewMain SET [STATUS] = '" &
Me.chkStatus & " WHERE [EMPLOYEE_ID] = " & Me.txtEmpID & ";"

CurrentDb.Execute(strSQL), dbFailOnError
 
Top