Changing Status on Multiple Records

[dvannoy]

in my database we track documents received at our facility. I have created a report that will only show completed documents ready to be billed. but the report searches by date. but they will release docs on different dates so thats not going to work. I would like to create a form with a list box and have that dept. change the status of the docs so they do not show up on the report once there status has changed. see the could be several pages to the doc but the same number.

how can i change the status of several documents with one check box? so that way they dont have to scroll through forms clicking each check box to close out that doc/page.

is a list box the way to do it? or can there be an easier way?...they dont even need to verify the doc only change the status..

Thanks in advance

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[JoeMiller]

Can you have them fill out the "DocNbr" and click a button that updates the status? I'm not really sure what you're trying to accomplish or your environment based on the initial post, but you can run an update query to do it in code?

[tt]
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE MyTable SET MyField = 'Blah' WHERE MyField = 'BlahBlah'"
DoCmd.SetWarnings True
[/tt]

HTH Joe Miller
joe.miller@flotech.net