updating multiple records at one time

[Krash878]

I need to be able to update multiple records all at the same time when a report is ran on them.

For instance I will run a query that will show me all of the records for the month of July that need to be billed. on that form I would like to have a button that says "BILL".
when that button is clicked I would like to generate an invoice for each record which is linked to a client. I will then need to have each record have the yes/no box IsBilled to be changed to yes.

Could someone please direct me in the right direction on how to acheive this.

Thanks
Kenny

 

[Maquis]

Just create an update query which will update your IsBilled field to true. Have the bill button run the query as well as open the report. Maq B-)
<insert witty signature here>

 

[Freckles]

What happens when you do an update query? : Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.

 

[Maquis]

It updates. (Sorry, I couldn't resist)


An update query will update rows in your table to the values you specify. You can refer to Access's help file for more detail. Maq B-)
<insert witty signature here>

 

[Krash878]

Thanks

Kenny