Originally Posted by
lowells
...Am I missing something about how Access updates records to a bound table from a form? One thing I'm confused about is why all the other edit controls on the form get updated automatically when I click the next record button but not the list box values for Responsibility? Why do I have to write a function to save those values?
What you have to understand is that when the Multi-Select Property of a Listbox is set to anything other than None...the Listbox Control has no Value Property! This is why the selections cannot be saved, automatically, like the Values of other Controls are, when you move to another Record...this is why you need a Sub Routine to save those multiple selections to a single, underlying, Field.
What you need to do is to
- Disable the native Navigation Buttons (Properties - Format - Navigation Buttons)
- Create custom Navigation Buttons
- Call the SaveSelectedResponsibility sub from the OnClick event of each Navigation Buttons as you already do when the Formis Closed/Unloaded
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007