Database Discussion - MS access combo box

Print Page | Close Window

MS access combo box

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21464
Printed Date: 29 March 2026 at 10:57pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MS access combo box

Posted By: urko
Subject: MS access combo box
Date Posted: 03 October 2006 at 3:52pm

im building a small script for myself and have one problem:

in Access - i havemain form and a subform that include following fields:

Category (ComboBox) - Independant
Product (ComboBox) - Dependent
Price (textfield)
Total

I would like that when you select lets say category1 from Combo box - Category,
that in Product combo box only products that are under that category would be displayed.

I have write this code but i always get items from category1


SELECT DISTINCT ARTIKLI.ID, ARTIKLI.Name,  FROM Products WHERE (((Products.IDKat)=[SubFormOrder]!IDKat)) ORDER BY Products.Name;

IDKat is the name/source of combobox 1 (Category (ComboBox)).

Thanks

-------------
Urko

Replies:

Posted By: PrivateEye
Date Posted: 14 October 2006 at 3:55pm

I am also looking for this :(

-------------
The Judgement Day