First off Hi all - I'm brand new to this forum and this community, but flicking through a few of the threads I can see that there seems to be a really nice helpful attitude here - which is refreshing to find on the internet!

I currently have a member of my team (who i expect will be registering here soon!) tasked with building an access application for me.

The database in question would deal with 'appeals', sent from other Managers to myself. In short the Manager using it would fill out a form - thus populating a record in the database, once they've completed their form and saved it, I would be able to open that record from my end, make a decision about the 'appeal' they have raised, and then mark the appeal as Overturned or Upheld.

The guy I have working on this is pretty good at this sort of stuff, but currently self taught with no formal training until I can get some organised. Most of what this needs to do he can already manage, however we're having problems with one feature I would like to have.

When someone completes a record, an email is automatically sent to me, to let me know I need to go in and assess the appeal, what I would like is for there to be a link in that email sent to me, that I could then click on - taking me to the exact record in question.

Any help would be appreciated.

Thanks

Steve

Hi Steve.

Welcome to the forum.

How is a record marked as complete? i.e. a checkbox?

A record would be marked as complete after "OnClick" - which then populates a table, which feeds to a second form with more options, which is the form I would open to mark something as overturned or upheld. The link in question would need to open this record on the second form - the one I use, not the one they enter the data in.

Ah I see, so you need the link as opposed to the email, right?

Yes thats the case - The guy I have working on it hasn't got a problem with making it send an email - its just that once I get that email I'd need to go looking for the appropriate record and as a lot of these get sent that can be a pain.

What would be nice would be to have the email sent automatically - and then when I look at that email I can just click on the link at the bottom which will open the record already completed by the Manager, but on the form that I can then complete as regards their appeal.