Microsoft's Issue Tracking Database Template

[jagstirling]

Does anyone know how the on the Issue Details form in Microsoft's Issues database template http://office.microsoft.com/en-us/templates/TC012253481033.aspx?pid=CT101428241033 refreshes.

I have added another page to include Other Assignees (meaning an issue can be assigned to more than one person) and I have manage to create a new form similar to the Add Related Issue form which allows you to select one or more contacts.

However, I cannot get the List Box on my new page to display the new contacts once they have been selected.

In summary ....

When I add a Related Issue and close the Add Related Issue form the list box on the Related Issues page (in the Issues Detail form) updates.

When I add a contact and close my newly created Add Other Assignees form the list box on my newly created Other Assignees page does NOT update.

Any help appreciated.

 

[jsv2002]

Without seeing what you have actually done to modify the sample database its hard to advise as I suspect its in the structure of your new forms and/or tables/queries that is causing the problem and not how it "refreshes"

How exactly have you added another "page" (assume you mean form) what is used to populate this? Would probably be more beneficial to post your modified DB or give greater detail on the changes you have made...

good luck John

 

[jagstirling]

Thanks for the reply John, I have attached my updated database as requested

I have modified the original Microsoft database thus;

Created a new form Add Other Assignees based on the Add Related Issues form
Created a new page Other Assignees_Page in the Issue Detail form and based on the Related Issues_Page

My problem is that the newly created Other Assignees_Page does not update when new contacs are selected via the Add Other Assignees form.

IMPORTANTLY, I owuld like to know WHAT mistakes I have made. This is a great forum for learning new skills and techniques.

Again, I'd appreciate any help or guidance, thanks.

 

[jsv2002]

Sorry someone else will have to help 2007 format and I have removed this from my machine at the moment causing to much hassle with 2003 installation until I set another virtual installation up.....

 

[speakers_86]

Here you go. Put this in the Add Other Assignees Form.

Private Sub Form_Close()
[Forms]![Issue Details]![Other Assignees].Requery
End Sub

 

[jagstirling]

Thanks, but there is no equivalent code in the Add Related Issues form so how does the related issues tabe/page refresh?

 

[speakers_86]

I am really not sure. As that part was made by Microsoft, I am sure it is in a macro somewhere. I looked at the macros, and do not see any coding for a requery, but I don't ever use macros, so maybe I missed it. However, the vba code I gave you above should work just fine.

 

[jagstirling]

Thanks speakers 86, your code works perfectly ......