Clear fields in a record

[stryder09]

Ok, So I have a form that I use as a set up form for weight challenges. On this form you enter a date the period of time you wish the challenge to go on for ex. 6 weeks. A Name for the challenge, select the people involved with the challenge and finallly the % of weight loss you want. Once this information is filled out you exit the form. I have it set up so that only the one form exists and another cannot be created.

I then have another form that draws all the information into it and I then Track weigh ins, body fat %, weight loss from the data from the setUp Form above.. I want to be able push a button and clear the data in the SetUp Form. I know how to delete the record but if I do that and I go back into the setup it tells me that I cannot create a new record because I have it set to only 1 record.

So how do I create a query that will clear the fields but not delete the record?

I tried using



DELETE [ChallengeName] AND [ChallengeStartingDate] FROM tblChallenge1SetUp

But this deleted the entire record.

As always any help would be appreciated

Brad

[pbaldy]

You'd want an update query:

UPDATE TableName SET FieldName = Null, AnotherField = ""

Depending on your specifics, either Null or "" might be correct.

[stryder09]

thank you I will try that today.

[stryder09]

Okay Final question. I now have a table which has 10 records in it. I want to just change record 1 using the Update from above. How do I specify that I only want to change the fields in record #1?

[pbaldy]

Add a criteria, like

WHERE FieldName = 1

[stryder09]

I have multiple fields to change. I put in

UPDATE tblBMI WHERE [ProfileNumber] = 1 Set [NameOfPerson] ="Profile1", [password] = "profile1";

It isn't working, should I try and write it a different way? I have more than just these two fields to update, more like 10 fields to update.

[pbaldy]

The proper syntax:

UPDATE...
SET...
WHERE...

[stryder09]

So it should be like the following?

UPDATE tblBMI Set [NameOfPerson] ="Profile1", [password] = "profile1" WHERE [ProfileNumber] = 1;

[stryder09]

okay rewrote it as

UPDATE tblBMI Set [NameOfPerson] ="Profile1", [password] = "profile1" WHERE [ProfileNumber] = 1;

And it works perfectly, thank you.

[pbaldy]

No problemo!