Hi all
I have an update query which runs as below
So it updates an entered value in the Charge field where an enetered value is found in the client field.
This works ok but I want to have the user control this through a form, rather than running the update query directly.
I want to have a dropdown box controlled by the Client table so they can choose a clent. But I dont know how to get this to update the table or run the update query.
Can anyone help?
I have an update query which runs as below
Code:
UPDATE [All Sales] SET [All Sales].Charge= [Enter Update Value]
WHERE ((([all Sales].Client)=[Enter Criteria]));
So it updates an entered value in the Charge field where an enetered value is found in the client field.
This works ok but I want to have the user control this through a form, rather than running the update query directly.
I want to have a dropdown box controlled by the Client table so they can choose a clent. But I dont know how to get this to update the table or run the update query.
Can anyone help?