Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+courses+in+london - Autopopulate Fields from a Combo Box
|
|
|
Bookmark this page|
The UK's most regular 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. |
microsoft+access+courses+in+london - Autopopulate Fields from a Combo Box
Resolved · Low Priority · Version Standard
Reply
Autopopulate Fields from a Combo Box
HiI 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
For upcoming training course dates see: Pricing & availability
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.
|
 |
|
» Forum post: \what is a database? |
what is a database?
