Calculated fields in table and Shared pictures on form are not allowing 2007 to open file.
EDIT: I see where I made my mistake and tried adding a value to a null field called Samoas and not the Samoas1 control
rpeare,
not sure why samoas1 = samoas1 + 1 is not working but it is not. I tried the same thing first and it failed to add to 0
trinstandoo,
Perhaps you can incorporate the text into the picture file so the user is not confused when the click a label. The following code will work in the click event of your image controls. THis will test for zero value.
Code:
If IsNull(Me.Samoas.Value) Or Me.Samoas.Value = 0 Then
Me.Samoas.Value = 1
Else
Me.Samoas.Value = Me.Samoas.Value + 1
End If
You want to place this in a click event so... (just like rpeare described) remove the text from the click event that describes your macro. Click on the elipses (...) and click "Code Builder". Paste the code into the new event handler. You will want to adjust hte code to match the respective control/field names.
Also, you may want to have your POS form not open at startup and open as a new order via another event, like a click event for a "New Order".