• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

whats wrong?

I have a button on my form with the following code in it

CN_Web.Status = "complete"
Vessel_Sum_Web.Status = "complete"

I want it to update the currently displayed records status fields to "complete"

Any ideas.

0
HudsonMarine
Asked:
HudsonMarine
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
You would run these sql codes in the command of the button if I understand you correctly:

UPDATE CN_Web
SET Status = "complete"
WHERE ID = Forms!Your_Form_Name!ID 'Key for record

UPDATE Vessel_Sum_Web
SET Status = "complete"
WHERE ID = Forms!Your_Form_Name!ID 'Key for record
0
 
Chuck WoodCommented:
If you have these fields bound to controls (like a text box) on your form (hidden or visible), you can just set the control.
txtCN_Web_Status = "complete"
txtVessel_Sum_Web_Status = "complete"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now