Help with updateing chk box in tbl

  • Thread starter Thread starter Chad
  • Start date Start date
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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top