On my first try all I get is a new record with the ID number I submitted. How do you make the form modify the values for existing records with that ID number?

UPDATE_
My Access file is connected as a file in the current web and verified through the database properties. The SQL query I have kluged together is...

UPDATE DISTINCTROW
PEIdir
SET proof=': :proof::', logo='::logo::', payment=': :payment::'
WHERE 'Member Class'='::Member Class::'

Thanks in advance.

[This message has been edited by maduko (edited 11-19-2001).]

If your using the DRW, check out some of Spooky's tutorials and links about updating at:
http://www.outfront.net/spooky/update.htm

If your built your own connections confirm that you don't have recordset.AddNew if your using that method. You just need recordset.UpDate.

If your using a SQL statement you need to have a WHERE clause in that statement.

Joe

I just discovered the tutorials and attempted the SQL statement. It didn't seem to work though.

What is your SQL statement?

Joe

I tried pasting the SQL from the example, modifying the field names to match mine. That must not be enough to make it click.

If you post your actual SQL statement we may be able to help you with it.

Joe

quote:

---

Originally posted by jbennett:
If you post your actual SQL statement we may be able to help you with it.

Joe

---

I thought I was getting a grip on it last night. It still puts the results in to a new row. Grrrr.

Here's the SQL...

UPDATE DISTINCTROW
PEIdir
SET proof=': :proof::', logo='::logo::', payment=': :payment::'
WHERE 'Member Class'='::Member Class::'

[This message has been edited by maduko (edited 11-16-2001).]

Make sure MemberClass (the form input) is one word.

If its numeric, then it should have no quotes

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
VP-ASP Shopping cart

I got it working and quickly discovered the Access zero-length trap. That's all happy now. But....

Now the concern is my update form can overwrite existing data without anyone knowing. For instance, we log a proof has arrived then another shows up a week later.

The only idea so far is to append the input to the field instead of replacing it. But I can't seem to figure out how to make that happen!

------------------
++++++++++++++++++
®

Hobby Time_ www.places2ride.com
Home Page_ www.maduko.com
Day Gig_ www.pei.org

Updating based on a text field may overwrite records.

The other way is to add a new dated record?

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
VP-ASP Shopping cart