Recent content by chucky

So putting me.requery in the after update of a text box will reset all the fields on the foorm or just the field that it is put in?

ok if i use forms![form]![field] = effort to put data into the table do i then have to go and also update the form as well with forms![form]![txtfield] = effort. If i should happen why does it not happen. for my form to update i have to close it and then open it again.

ok effort is a variable that i am using. Thanks for that about the field name and text box. I thibk i do have a few that clash. I will go and fix them up. thanks for the help.

so instead of using text/value just use the field name when getting or assigning text to and from the fields

I am trying to assign text to field in the main form. but can't get it to work. I have tried the following. the these error occur. A) Forms!FMSServerDetails11!EffortH.Value=effort run time error "2448": you can not assign a value to this object. B)...

am new to acces so it may be easy. I have a form with a subform. In my sub form i click a check box and change the specific component price. Then on that field change i want to change the total price of the quote, this is in the main form. So basicaly i want to change the field in a form from...

ok i have not used access much but i have studied vb. I am trying to makes a programme so that on click of different check boxs, it updates multiple fields. I think i have the code right but when i run the form and click on the specific check box i get the following error. The expression On...