Richard uses a combo box in the appointments form to get customer names from customers table so the right customer is displayed in the form. It uses customer ID in combo box to get customer and hides the ID column. But what if two or more customers share same first and last name - how do you know you have the right customer. You dont want to put appointment details that pertain to wrong customer. Would displaying additional fields in combo box like address information help to narrow down and icrease accuracy of customer search in the combo box. Also - maybe cos i am new how do you add a new appointments details to this form not just see the customers historical appointment details.
John Williams
@Reply 5 months ago
Yes, you can add multiple columns to your combo dropdown. Add the extra fields to your query that populates the dropdown list, and adjust your number of columns and widths to show what information you need.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 2.