Results 1 to 3 of 3
Thread: Field fill-in from combo box
2015-01-10, 00:20 #1
- Join Date
- Jan 2001
- Kendrick, Idaho, USA
- Thanked 0 Times in 0 Posts
Field fill-in from combo box
I have a saved sample to remind me how to setup an unbound combo box that displays records of a table. Other text boxes in the form are filled in from columns of the selected record. The control source for the text boxes uses this pattern: =[SchoolID].column(3).
My original example was created in Access 2003. In Access 2010, the reference is automatically changed to have brackets around the word Column: =[SchoolID].[column](3) and #Name? is displayed instead of the school name.
Will someone explain what happened and hopefully, how to fix it?
Thanks so much
2015-01-10, 18:30 #2
- Join Date
- Dec 2009
- Midwest, USA
- Thanked 5 Times in 4 Posts
This appears to be a change in the Jet database engine. It blocks what it considers unsafe references or actions. You can work around it by making a change in how sandbox mode is set on your computer. You can see how to do this in this thread from google groups access group. https://groups.google.com/forum/#!to...ss/8S5P-MvQE4Q Read the thread an you will eventually get your answer, it is quite a ways down in the thread.
Here is the link for how to change the sandbox settings: http://office.microsoft.com/en-us/ac...010342092.aspx
Maybe someone else here can explain the dangers of making this change.
2015-01-11, 10:37 #3
- Join Date
- Aug 2001
- Evergreen, CO, USA
- Thanked 58 Times in 58 Posts
My personal opinion is that there is only minimal danger is changing the sandbox mode in 2010. The security features that were introduced in 2007 and beyond were intended to make it less vulnerable to malware, but there have been very few cases of Access based malware that I am aware of. It seems there are much easier applications, which are more widely used, that black hats focus on.
There are also other ways of achieving what you are apparently doing. The most common one is the one used by the combo box wizard, which does a record set clone each time you select a record in the unbound combo box. The other common approach is to apply a filter based on the selection of a record in the combo box. Both do require using VBA of course, but are not affected by the sandbox issue.Wendell