CODEWITHSUNDEEP
ms-accesscombobox
ilitirit
ilitirit

Reputation: 16352

How to open a form in Access, automatically select a value in a combobox and display the detail?

A user can select a value in a combo box and the detail automatically loads into the forms fields. How can I automatically select a particular value when (or after) opening the form and get the detail to load?

I've managed to set the value of the ComboBox after opening the form, but the detail on the page doesn't change until I manually select a value in the ComboBox.

Upvotes: 0

Views: 1879

Answers (1)

Fionnuala
Fionnuala

Reputation: 91376

Is the subform built with code or more simply by setting the link master field to the combo and the link child field to the matched field for the bound column? For the most part, the second way is best as it does not require the After Update code for the combo to be triggered, which won't happen when the value is set via code.

Upvotes: 1

Related Questions