microsoft+access+courses+in+london - Autopopulate Fields from a Combo Box

Resolved · Low Priority · Version Standard

Wed 14 Mar 2007, 16:13 Delegate Brian said...

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

Tue 20 Mar 2007, 11:40 Edited on Tue 20 Mar 2007, 11:43 Trainer Carlos said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips