Record not updating

[sjurick]

I had a beautiful application working, decided to rename a few of the database
fields and change the data types to decimals to enhance the app and now I
cannot get a record to update on my existing update page. I have deleted the
recordset and readded it (no red exclamation points), and relinked all the
fields and even changed the URL parameter on the main page which the EDIT link
is on. I get the correct record to display on the edit page and even the two
dyamic fields are displaying the correct data however when I click to update
the record, it doesn't update. Help please!

[Philo]

Sometimes this happens when the datatype source and destination are
different. Since you changed some datatypes be sure that your update
uses the correct datatype. You did not say if you recoded you update
but my guess is you did not.

[sjurick]

On the first instance of this problem I did change the datatype from integer to
decimal. Went back and changed in the Update behavior to Double so that I
could see the decimal values. Still can't update records in that database but
I have a new issue with a database that is strictly VARCHAR across the board.

I had the update page working which was built using the Update Record Wizard.
Linked and EDIT button and that worked too. Updated records just fine. Went
to change one of the fields to be a dropdown list box with the Dynamic value
linked to hold the proper choice in the Update page and now I'm getting the
same behavior. Record displays properly when clicking Edit, values look right,
then I make a change (any change - not just a dropdown choice) and I get taken
back to the original page but no update. This is very frustrating.

Steve