X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> How To Make Listbox And Selected Records In Other List Box, Access 2007    
post Dec 23 2017, 05:26 AM

Posts: 251
Joined: 31-July 10

I am Using Access 2007
I have three Tables Namely tbldishes (pk DishID) ,Ingredients (pk IngredientID), DishIngredients (pk DishIngredientID)

what I am trying A listbox (say SelList) populate with DishInredients from tblDishIngredients based on tblDishes DishID and than from this list IF select any Ingrdient goes to Other Listbox (say Selected)

how I can do...?

Please help me. Thanks in advance


Go to the top of the page
post Dec 23 2017, 07:47 AM

UA Admin
Posts: 34,335
Joined: 20-June 02
From: Newcastle, WA

There are multiple steps involved to complete this task.

First, you need to implement a variation of the Cascading Combo Boxes technique. In your case, though, the second control will be the list box instead of a combo box.

Then, there are multiple techniques for selecting items from a list box and displaying the selected items in a second list box.

The exact implementation depends, in part, on what that second list is and how you plan to use it. How do you plan to use it?
Go to the top of the page
post Dec 23 2017, 08:06 AM

UtterAccess VIP
Posts: 10,509
Joined: 10-February 04
From: South Charleston, WV

Will you type in the table layouts of the 3 tables and then give an example of what you're trying to achieve?
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    20th January 2019 - 04:09 PM