Solved

whats wrong?

Posted on 2009-07-01
2
174 Views
Last Modified: 2013-11-28
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
Comment
Question by:HudsonMarine
2 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24757962
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
 
LVL 16

Accepted Solution

by:
Chuck Wood earned 500 total points
ID: 24758114
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

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question