I'm trying make a form that uses two text fields, "customerId" and "itemAmt", and two buttons, "add" and "subtract", and when you click on the 'Add' button it increases the "itemAmt" by one for that item for "customerId". Both "customerId" and the values of "itemAmt" are in the same table, and the "itemAmt" values are all numbers.

I have tried everything that I can think of, and have looked in multiple places for any sort help, and I have found nothing that will fix this.

Actually I put up a post on this a long time ago...in a galaxy far way...LOL...but darned if I can now however..so.

You could hard code this for your particular form ( meaning this particular column in this specific table ) or you can do this by creating a generic type of macro that you could use. ( this is only good for integers...but you could expand it to handle other data types also )

sub onAdd_1_ButtonClick( oEv as object )'' events such as mouse clicks always call' a procedure or function with a paramter of' type eventObject' the eventObject will have a property Source' which here is the graphic button' A deffernce between the source object' we get in an event handler call' and from XDataForm.getControl( )' is that in getControl the return is a' control's model'' Here we have the instance of the control' so to get to the parent Dataform object' we need to go via the model

dim oDataForm as objectoDataForm = oEv.Source.Model.Parent

' then call our incColumn procedure' the idea here is that the procedure actually' assigned to the button event just sets up' the paremeters for a general function'' incColumn will update our actual table field