Recent content by sarkis

Thank you for respond. I understand what was a problem. Actually records are changing ,but it doesn't appear in the form. The form is need to be "refreshed" or make some change the record position on the table. (I don't know how to do that) Anyway thanks again

Thank you for respond. Problem was not on in the Null value I understand what was a problem. Actually records are changing ,but it doesn't appear in the form. The form is need to be "refreshed" or make some change the record position on the table. (I don't know how to do that) Anyway thanks again

Thank you for your patient. But your code doesn't work. It doesn't increase the id1 value.

text box works ,but click event doesn't. I need to work click event.

I didn't get any error. It seems me that click event doesn't run.

Hi again I have still a problem. I have a simple form with a text box and a button. The control source for a text box is a numeric field id1. I am trying to increase the value of tables field by clicking button. Here is a click event. Private Sub mCommand1_Click() Me.id1 = Me.id1 + 1 End Sub...

I did it and text box control works. But I don't need to change value with a text box control. Even if it is a text box control ,it should be read only and value of the field should be changed only by click event.

Here is the code. Private Sub mCommand1_Click() Me.id1 = Me.id1 + 1 End Sub I tried to debug, (I put a debug sign behind the code line ) but it seems click event didn't happen. I change label to textbox end it shoes values.

Thanks for answer. But It doesn't work still. There is no any reaction no errors. It seems me that code is not even calling. and I need to change tables value ,not only on the form. Should it change the fields value if we change the controls value?

Hi all, I am beginner and may be my question is stupid but I cannot do that. So, I have a table - Table1, a numeric field - id1 A form Form1 ,on the form label- Label1 which shows Field1 value (instead of Label may be another control) a button -Button1. I need to increase Field1 value by 1...