473,805 Members | 1,887 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Limiting options in one combo box based on the selected item in another combo box

36 New Member
I read, and grokked the following thread:
http://www.thescripts.com/forum/thread577386.html

and it worked for me initially.

However, I tried using it on a an AutoForm generated form, which contains a subform, and it no longer works! I'm not sure what's going on - it is complaining about not being able to find the subordinate control from the master combo box's event script.

When I try to enter the second (i.e. dynamic) combo-box, I now get prompted for a parameter to the query. It seems that the query is unable to access the controlling widget with the Form!DbaseName! Control syntax.

Do subforms change the structure of the object tree?

Also, there a way to access the current record (i.e. at the cursor) in another database from within the query criteria? Could I use something like Table!DbaseName !Field_name ?

thanks in advance,
-cybervegan
Jan 15 '07 #1
1 1497
acoder
16,027 Recognized Expert Moderator MVP
Looking at the thread you mentioned, this is an Access problem.

Post your problem in that forum unless a moderator moves this thread there first.
Jan 15 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3741
by: Daniel Hill | last post by:
OK, I have very, VERY basic background knowledge of VB6 and have now upgraded to VB.NET and now I'm struggling to bring up the forms I want. What I am looking to do is to have a click a command button bring up a form, and to have which form is brought up determined by which item is selected in the accompanying combo box. I've gathered that you have to declare the item as a
1
2573
by: dimension | last post by:
Hi, I have a combo box that is bound AFTER a user makes a selection from another unbound drop down. The problem is, the SelectedIndex of the combo box is always initialized to 0, not -1. This makes it difficult to determine whether an item was selected or not, since the items collection is Zero based also. Additionally, in the code that does the binding, when i set the Datasource, Valuemember and DisplayMember properties, the...
2
2408
by: Robert | last post by:
Am using a nested continuous bound subform to add multiple records to the underlying table. One of the fields is based on a limit to list combo box. Any suggestions on best way to progressively update the combo box query so that for each new record being entered the combo box list excludes items in the combo box list previously selected. Aim is to prevent user from selecting the same combo list item more than once if the user has already...
4
1770
by: Mark L. Breen | last post by:
Hello Guys and Galls, I use combos on my forms. The code to initialise the combos is as follows Dim dsPIDTypes As DataSet dsPIDTypes = PartDB.GetPIDTypes ' Returns a dataset object cboPIDType.DataSource = dsPIDTypes cboPIDType.DisplayMember = "tlkpPIDType.PT_Type"
1
6140
by: sara | last post by:
I am learning how to use simple functions to make my apps more powerful and efficient. On one screen, I want to populate field B: ItemDescription by looking up the ItemDescription in the Items Table. I would use the key to the Items Table from the selection the user made in the combo box. SO: User chooses an item from the combo box whose value is "3". I want to look up the ItemDescription of the Item with the Key "3" and show that...
2
1491
by: wcrackshot78 | last post by:
I currently have three list boxes on my form, the information on each one is determined on what was selected on the one before it. The problem I'm having is the information that is used is pulled from another program and is duplicated a lot. Example Type Make Model Car Ford Mustang
2
2102
by: Tony A. | last post by:
The application I'm working on has three tables State, Customer, Orders. In the first combo box the State is selected. Based on the State selected the second combo box will be populated with the Customers in that state. Based on the Customer selected a datagrid will be populated with the customer's orders. I setup the query for the secont combo box as follows: Select CustName From tblCustomer Where State = @cboState
7
2441
by: callawayglfr | last post by:
I am building a database in access where I have a drop down box that relates to a text box, that part I have working but when someone selects information from the first drop down I need it to limit the second drop down to just the related information. Explaining this is obviously challeging. So I'll try to draw a picture: (drop down 1) Select number --- once selected description is populated in text box (drop down 2) based on first...
4
2793
by: Gord | last post by:
When clicking an item from a drop down list on a combo box, how does one make another combo box make a selection from it's own list? No matter what event I use for my code in the first combo box, seems to always generate an error when I try and refer to the other combo box. I'm aware of the necessity of setting the focus on the second box before referring to it, unless one is using the default value. I'm too tired to type out...
0
9716
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9596
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10360
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10105
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9185
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6876
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5542
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5677
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3845
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.