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: 247
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: 33,017
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: 9,819
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?

Robert Crouser

My company's website
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    17th July 2018 - 02:11 PM