98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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
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 information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Combo box for finding recordsYou 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 |