lookup Combo Box

[ct2013]

When I insert a new combo that should pull down records in my columnar form, the combo on select will only pull that record up once i have been into design mode or something similar and every time i reopen the form it just doesn't work.

Does anyone know if there is a fix for this most annoying bug in my DB.

Ta

 

[missinglinq]

This scenario is usually the result of the Database residing in a Folder that has not been declared as 'trusted.' In version 2007 and later, VBA code won't execute unless the folder holding the database has been designated as a "Trusted" location.

To "Trust" your folder, click:

• Office Button (top left)
• Access Options (bottom of dialog)
• Trust Center (left)
• Trust Center Settings (button)
• Trusted Locations (left)
• Add new location (button)

The code works, when going from Design View to Form View, because the Access security is only invoked when opening the Form directly, i.e. clicking on the Form in the Navigation Pane.

Linq ;0)>