Update Database

S

SS

Hi

I have a form that updates a database but I have one field that is a comment
box and if filled it puts the information in for every time the name
appears.

I originally had WHERE FirstName='::FirstName::' and LastName='::LastName::'

This works but does what I said above. I want it to only put it in on the
particular record

I've tried

WHERE ID='::ID::' and FirstName='::FirstName::' and LastName='::LastName::'

but then I get an error.

Is there a way around this?

Thanks Shona
 
Top