Using MS KnowledgeBase article Q275563 I constructed two functions. One function is required because it is how you assign an array to a combobox in Access.

You can greatly enhance a form by having Access supply information based on the user's selection. Here's an example that will fill in an employee's first name and phone number when the user ...