Update Field

[blue4512]

I am sure this question has been asked a million times - but I can't find the answer I need.


I need to update a a field in a record once a field in a a different record is updated.
I have used Macros to accomplish this but the process is taking too long, it updates the entire table. I don't see anywhere I could set a where to only reference the one record.

Any help would be greatly appreciated.

[June7]

The WHERE would be set in the SQL UPDATE action statement. I don't use macros, only VBA, like:

CurrentDb.Execute "UPDATE tablename SET fieldname=" & <input value1> & " WHERE ID=" & <input value2>

The input values could be references to controls on form.

Why do you need this update? Is data being duplicated between tables?

[blue4512]

Once a service that is linked to an estimate is authorized I want the estimate to change status to authorized, I don't think this is duplicating information. Can I add the WHERE statement in VB and still utilize the macro? I do not use VBA and am somewhat intimidated, although I should learn!

[June7]

Is the status field a Yes/No type? You want to update only one record? What are names of the linking pk/fk fields of these two tables?

Not sure what you mean by 'add the WHERE statement in VBA and still utilize the macro'. As far as I know, macros can call VBA user function procedures but not sub procedures.

Should be able to build an Access UPDATE query object with the appropriate syntax and parameters and run the query from macro.