UtterAccess.com
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    
 
   
khalakmu
post Dec 23 2017, 05:26 AM
Post#1



Posts: 248
Joined: 31-July 10



Hi,
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

Khalakmu


Go to the top of the page
 
GroverParkGeorge
post Dec 23 2017, 07:47 AM
Post#2


UA Admin
Posts: 33,760
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
 
projecttoday
post Dec 23 2017, 08:06 AM
Post#3


UtterAccess VIP
Posts: 10,160
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    18th October 2018 - 06:18 AM