approving data entered into a database

[fredstar]

Hi All
First post and I really really need some help. For my work I have created an incident reporting database based on the Desktop Issue tracking database that can be downloaded in MS Access 2007 from the MS website.
I have made a fair few changes to it and it seems to be working well. Managers now want their staff to be able to enter their own issues but have them approved by the manager before being saved into the database.
How do I go about this?

The DB does get the username of the person who is logged into the pc if that helps.



My access and VBA skills are very limited and most of what Ive done in the DB has been with the helop of google searches.

Thanks

[pbaldy]

One method would be to control them with a status field. Let new issues into the database, but give them a status of "U" for unapproved or some such thing. Provide a form for managers that lets them change that field.

[fredstar]

Thanks for the reply. I will try that suggestion but Im also using fOSUserName function to filter what each staff and manager can see. There are different teams with their own managers and staff that use the DB.

[pbaldy]

No problem, and welcome to the site by the way. Post back if you get stuck.