List Box or Combo Box - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

List Box or Combo Box

Harold Laski

4 years ago

I have a customer form containing customer information. I would like to create a list box that contains information from the product table and payment table. The Order Table contains a linked customer ID, OrderID, Order Date (OrderDate) Order Description (OrderDesc) and Order price field (ProdPrice). In the Payment Field is the PaymentID, Payment Date, PaymentType ( like cash,check CC) and DaymentAmount fields. How can I add a list or combo box to show all of this and allow me to click on an entry and go to that entry to change it using the appropriate form?

	Kevin Robertson @Reply 4 years ago
Yes. Build a Query containing both tables and add the fields you need in your List Box. To open the correct form just make sure you add both IDs. You can then open the appropriate form with a couple of buttons.

	Harold Laski OP @Reply 4 years ago
Can you guide me to a Course that will guide me to create the working list box on my CustomerF form? I purchased all the courses so I have access to them all.

Scott Axton @Reply

4 years ago

You say you have the courses but how many have to progressed through?
Richard says a lot, "I give you the Lego pieces. It's up to you the developer to decide how you want to put them together to do what you need.

Now is the time to learn the navigation around the site. Make the Search box and the Index your best friends.

Go to the Access Index

Use Ctrl-F (Find) to search the page.

Some different searches
List Box
Double Click
Open Selected

Command Buttons

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View