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