How do I run an update query from a user form

BillyDo

Registered User.
Local time
Yesterday, 23:09
Joined
May 19, 2011
Messages
17
Hi all

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?
 
Look at "DemoUpdateClientA2000.mdb" (attachment, zip).
Look at Table1, Query1Update, Form1 (VBA).
Open Form1 and try.
 

Attachments

Users who are viewing this thread

Back
Top Bottom