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

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.