Updatw table with a given criteria

  • Thread starter Thread starter rasheedvtk
  • Start date Start date
R

rasheedvtk

dear all ,
i have one single tablewhere i used to keep all my purchases, i want all the
the invoices on a specific date to be marked as paid , i want to it using a
form,
like this i have one form update paynebt status form ,when i click th update
command button on this form another form shuld pop up asking ,invoices on
which date shud bemarked as "paid", i dont know what code i will use to run
the update query on click on the command button, can anybody help please
 
dear all ,
i have one single tablewhere i used to keep all my purchases, i want all the
the invoices on a specific date to be marked as paid , i want to it using a
form,
like this i have one form update paynebt status form ,when i click th update
command button on this form another form shuld pop up asking ,invoices on
which date shud bemarked as "paid", i dont know what code i will use to run
the update query on click on the command button, can anybody help please
Click to expand...

The toolbox command button wizard has an option "run a query".

Just save your Update query as a named query, and create a button on your form
using the toolbox. Have the magic want icon selected, and follow the menus.
 
Back
Top