Alternative to VBA Update Query

pace123

Hi,
I need to update a field [Cost] on another table [Parts] from a form [Supplier].
Eg: on my [Supplier] form, I enter a cost which will update the [Cost] field in the [Parts] table.

I can write an SQL query in VBA but is there a simpler way to do it with the expression builder?

Thank you very much, Paul

PEB

You can do it using running SQL or writing loop process that does the update!

It seems that you create an SQL and start it from VB

But you want an other way?

Only using expression builder???? Create what with it? SQL or VB function? This is a tool that facilitate but till!!!

If you are interested on looping the records updating them tell us!

Alternative to VBA Update Query

re: Alternative to VBA Update Query

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about