Brian has attended:
Access Advanced course
Access VBA course
Autopopulate Fields from a Combo Box
Hi
I have a form on which I use a combo box to select a value to place into a field. The combo box runs a query to generate the data and actually selects and displays four fields, the data from one of these populates a field in my form when selected. I would like to be able to use the data from the other three fields in the query to complete fields in the form - but the combo box wizard only alows one field to be selected. How can I get around this.
Thanks
Brian
RE: Autopopulate Fields from a Combo Box
The way to autopopulate fields based on a selection on a form is by using VBA.
The code would use the value selected in the combo box as a condition to rerun the query.
Then take the results in the corresponding fields in the query and place them in the form's target fields.
