98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Forms
Forms
Resolved · Urgent Priority · Version 2003
Fri 15 May 2009, 12:46Delegate Fiona said...
Fiona has attended:
Access Intermediate course
Access Advanced course
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.
Mon 18 May 2009, 09:20Trainer Stephen said...
RE: Forms
Hi Fiona
Thank 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.
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:Hiding Multiple Table columnsIf you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide. |
