microsoft+access+courses+in+london - autopopulate fields combo box

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+courses+in+london - Autopopulate Fields from a Combo Box

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

resolvedResolved · Low Priority · Version Standard

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

Edited on Tue 20 Mar 2007, 11:43

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.


 

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


Server loaded in 0.09 secs.