Append Query

[BluBluMeany]

Hi,

I am building a database to hold information of training courses and staff that have requested or completed the training course.

I have built a form which the team leaders can use to request training for their team, basically when the form opens up it asks for team name and training session and then appends the names and training session ID to the main table. This then allows the team leader to tick the "request training" tick box which updates the table for each member they request trainig for.
They would then send this using a custom command button which is linked through outlook.

The problem I am encountering is that if they were to selct the same team and training session again it would then append the same data to the table and this would create duplicate entries.

How can I set it up so it appends only once and then any other time the same data is selected by team leaders it would populate the form with the existing date rather than appending the same data.

thanks in advance.

 

[frozbie]

Sounds like you are trying to do two different things:

Append data where it does not exist
Update data where it does exist and needs changed

If this is the case you need to first check to see if data exists and then depending on whether it is, either update or append.

I am working on an archiving routine just now which will combine VBA and queries to do a similar thing. Once I get it finished will post it. If you beat me to it, let me know

Frozbie