Update a form 1

[lpgagirl]

I have a form that acts like a bulletin board to communicate information to other shifts. It has an auto number assigned when a new bulletin is created. There are a number of check boxes that are checked by employees to acknowlege that they have read the bulletin. There are instances where the bulletin needs to be updated with new or changing information. I have added a button called "Update Bulletin" that gets clicked when the user has entered new information. The button clears all check boxes so that employees know that there is an update and must click their check box once they have re-read the bulletin. The bulletins are sorted via the autonumber.

I would also like the "updated" bulletin moved so that it it becomes the most recent bulletin when the "update bulletin" button is clicked(sometimes updated bulletins are getting missed because they are at the bottom of the pile)

How and/or what do I need to do to make this happen?

Thanks in advance,



Jeannie

http://www.thefloyds.50megs.com

 

[Remou]

How about a last updated field (datetime) that can be used to order by?

 

[lpgagirl]

Great solution. I also made the field hidden so it works like magic! hehehe

Thank you

Jeannie

http://www.thefloyds.50megs.com