Table for specific records containing hyperlink ID

[kets0985]

Hello,

I am creating a task tracker where the user will enter a task which is working. If he is complete the task at that moment he will submit the task and everything is done for that task. However, if there is some issue or if the user need any information, then the user will enter a comment and will hit hold.

My queryis once the user hits hold button, the table "Main" will capture the hold date and time. I need a second table, may be by name "Inbox" which will only show records kept on hold.

Secondly there should be hyperlink for "ID" of Hold records in table "Inbox" and when the user click on the the "ID" to resume the task, it should take the user to "Main" form and display that particular record (record which the user had clicked). Also, the date and time should be recorded when the user click on the hyperlink in Resume_Date and Resume_Time fields for that record.

Kindly request you to assist me to built my desired database.

Thank you.

 

[burrina]

I did not download your db but it sounds to me that a subform would work for this.
As for the time/date you can simply do a requery.

 

[kets0985]

I have tried what I can do...but I am not that much proficient in access and would need your help to do it..
I would be thankful to you, if you could help me to materialise it.

 

[kets0985]

I have tried what I can do...but I am not that much proficient in access and would need your help to do it..
I would be thankful to you, if you could help me to materialise it.

 

[burrina]

What have you done so far? Can you show your relationships? Form Designs?

 

[kets0985]

I have attached a file where I have created a simple form which I will use to track my daily task.

I want to crete a table of hold records with hyperlink.so that when I click on hyperlink I should be able to go to that record

Can somebody help me on this, please.

4 conversations but nothing received which can help.