I'm not sure what you're talking about, Steve. As far as I know, table view saves data fine unless something is read-only or you have a NotifyForm flag set to prevent saving. Under what circumstances does this occur?

Erika,

I see that the fields are retaining the changed data when I tab out, but the changes are lost when a command button with programming is pressed. I guess I can make the first line of the command button 'formcommit()' but that does not seem like a proper solution.

Any thoughts?

Steve

Yes, you are correct. It's on my invoice type form while changing data on a line item. Seems that the data is not committing.

I don't see this happening in my other aps. Could there be some form programming that would prevent the data from committing to the database?

Steve

Yes, Ray. That is usually, if not always, the case.

Ray,

Adding formcommit() to the top of the program fixed the issue....but why do I have the issue?

I don't see anything in the button code that would cause this issue. The subform has no programming in the form itself or any of the elements. The 'calculate' button that triggers the data loss is below. Perhaps Visibility() or Clear() commands are causing the form to 'reload' and wiping out the changed data? (The code below is a subroutine stored in 'global code' of the parent form (var's are allowed there?)
[quote]
subroutine calculate()
var x as int = 1
var vstatus as string
var vamount as double = 0

visibility(please wait,1)
Clear(back ordered,amount paid,subtotal)
subtotal = 0
tax = 0
total = 0

while x <= @formresultsettotal("order")
{
vstatus = @formfieldvalue("Order", "status",x)
if vstatus = "New Order" or vstatus = "In-Progress" or vstatus = "Shipped" or vstatus = "Complete" or vstatus = "Pending" then
{

subtotal = subtotal + @tomoney(@formfieldvalue("order", "selling Price",x))
vamount = vamount + @tomoney(@formfieldvalue("order","Amount paid", x))
}

if vstatus = "Back-Ordered" then back ordered += @tomoney(@formfieldvalue("order","selling price",x))

vstatus = ""
x=x+1
}

if taxable? = 1 then
{
tax = subtotal * @tonumber(@globalvalue(@userid+"taxrate"))
amount paid = (vamount * (@tonumber(@globalvalue(@userid+"taxrate")) +1))
}
else amount paid = vamount
total = subtotal + tax
visibility(please wait,0)
END SUBROUTINE
[/quote]

Hello Steve,

The four statements that are

@formfieldvalue("Order", "status",x)
@formfieldvalue("order", "selling Price",x)
@formfieldvalue("order","Amount paid", x)
@formfieldvalue("order","selling price",x)
 

are moving to a different subrecord than the current one as 'x' will be every record in the subform. Since the subform has not been told to save the changes to the record that has been saved, the changes are reverted.

-Ray

Quote:


So to fix this issue, I need to add a formcommit() at the start of each command button program (to save the changed data that the user typed into the subform field), as well as during the program, just before the 'x = x + 1'

Is that correct?

Thanks for clarifying.

Steve