Me?

[lead 27]

Hi

I am just wondering if anyone knows:

If I want to change a field on the current form I start the code with Me. However is it possible to change every record for that field in the table so I assume it might be instead of

me.[fieldname] = ??? it would be

[tablecode].[tablename].fieldname]= ???

Thanks

 

[Rabbie]

If the field on the form is bound to the table then the table will be updated automatically. otherwise you probably need to use VBA to update the record.

 

[lead 27]

Thanks for your quick response. The field is updated in the table for the current form that I am on however this will only update one record in the table and I need it to update every record in the table.

Thats why I was thinking that me. means current form so is there a way to say this field on every form in the table?

 

[Rabbie]

If you want to update every record in a table then an Update Query is the best way to do this.

 

[lead 27]

yeah I have looked into this but I will need it to update every time the information is changed which will be quite oftern.

 

[Rabbie]

If you build the SQL string in your code then you can fire it off with a Docmd.RunSQL.
This should mean you can make it reasonably automatic if its always the same field in the same table. Then I would guess you only need to insert the new value for the field and possibly you will need to alter the Where clause to select the right records.

 

[lead 27]

What do you mean by build the SQL string into your code?

 

[lead 27]

I think that I have it sorted now but do you know how I can stop the warning boxes coming up asking if im sure etc?

 

[Rabbie]

Go to Tools --> Options --> and then in the Edit/Find tab uncheck Action Queries in the Confirm area.

 

[lead 27]

Thats great thank you for your help