Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Forms
|
|
|
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. |
Forms
Resolved · Urgent Priority · Version 2003
Reply
Forms
I want to create a Client List in forms using a combo box, but when I use the wizard, I can select First Name and last name from another Table,( which I want to Link) , It will show First and last name in the drop down list, but selected it will only choose the first or last name ( not together). How can I link the first name and the Surname together in the same combo box.For upcoming training course dates see: Pricing & availability
RE: Forms
Hi FionaThank you for your question
A combo box will only show one field when not selected.
If you need to see multiple details, I would suggest replacing your combo box with a list box. This will show multiple columns so you can see all the details you require displayed on the form. They can be set up using a wizard, or by writing an sql statement in exactly the same way as a combo box.
Regards
Stephen
Tue 26 May 2009: Automatically marked as resolved.
|
