I'm having a problem with SQL 2000 where for example the street address column is over writing the state column for every user that is entered. Everytime data is entered in to the state column it somehow grabs the data from the street address column when the proceed button on the app is depressed. Any assistance would be appreciated solving this.
Kindly check your sql query, it seems like you've goofed up the variable names in your application. Try and show the SQL query in a MsgBox before executing it.