Hi,

Using Access 2010 and the "Issues Template" on a SharePoint site.
I want to add a bound combo box called project to the Main form. So for each different ProjectNumber I can add an issue.
The field in the combo box (and Bound Table field) is ProjectNumber, and I want to be able to add any new project numbers to the list and hence the bound table.
The list being populated from the table - Project.
The Combo box will sit in the Main form.
Old method was using the Not In list event.
As a web based template can only use macros - how do I get around this? Can something similar be done?
I want to limit the list - hence - Not In List (do you want to add a new project Number, if not then select from the list).



Each user as They login, selects a project number to add an issue etc.
When they add an a n issue, the project number is added along with user name etc.
So what ever is selected in the combo box, any issue that is new will be related back to that project.
Thanx for your consideration.