3rd and 4th combo boxes don't pull the correct data

Stephanie Wright

I'm having a probem with my 3rd and 4th boxes not showing the correct
data to pick. My database is normalized and I have Me! statements for
each combo box in the After Update but something is quirky about it.
Also I have a subform that is supposed to show the results and it does
for the first 2 but not for the 3rd and 4th. I'm not using the child
link method, it's in the code for that too. Any ideas what might be
wrong?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #1

Subscribe Reply

1296

Larry Linson

"Stephanie Wright" <cw*****@zbzoom .net> wrote in message
news:40******** *************@n ews.frii.net...

I'm having a probem with my 3rd and 4th boxes not showing the correct
data to pick. My database is normalized and I have Me! statements for
each combo box in the After Update but something is quirky about it.
Also I have a subform that is supposed to show the results and it does
for the first 2 but not for the 3rd and 4th. I'm not using the child
link method, it's in the code for that too. Any ideas what might be
wrong?

The AfterUpdate event of each combo box should .Requery the next ComboBox in
the "hierarchy" , and each should include the value of the previous Combo in
its RowSource as a criteria. As to the Subform, without seeing the code, we
couldn't guess what might be wrong with it (if anything). We'd also need to
know where that code is located. It would be interesting to understand why
you did not use LinkMasterField s and LinkChildFields (note that both are
plural, so can refer to more than one field or control on the main form, and
that's usually the easiest and most reliable way -- you will also need to
Requery the Subform Control after setting the last of the Combo Boxes).

Larry Linson
Microsoft Access MVP

Nov 12 '05 #2

Similar topics

1669

For XML Schema gurus - populate 2 combo boxes from schema data

by: Joyce | last post by:

The XML Schema design problem to solve is as follows: We have 2 combo boxes to populate from schema data, let's say: 1. States 2. Cities (and this one gets populated depending on the choice of the state) The event management is no problem, the question is, how do we build our XML Schema (that's going to contain the data for both states and

.NET Framework

3316

How can I use a combo box to advance records on a form?

by: FZ | last post by:

Hi Gang, I was wondering if a generous person might be able to walk me through what I believe is a pretty simple task. I actually have significant Access experience, but I haven't done it in about 3 years and I'm more rusty than I thought I was. Anyway, in a nutshell: The scenario: 2 combo boxes (comboLastName and comboStateorProvince) on a form with 30 text boxes, the form's recordsource has been set to a query, both combo boxes and...

Microsoft Access / VBA

2598

How to use combo box in query by form?

by: RBohannon | last post by:

I'm using Access 2000. I currently have a report being generated using the results of a query by form. The form used for this query is an unbound form, frmListDialog. frmListDialog contains two unbound text boxes, txtExamTitle and txtExamNumber. The user enters either the exam title in txtExamTitle or the exam number in txtExamNumber as a parameter for the query. This is currently working fine, however because the exam titles are...

Microsoft Access / VBA

1866

Using a combo box on search form

by: dskillingstad | last post by:

Would appreciate any help I could get I have an unbound search form with various text boxes on it for searching my database. I would like to have a combo box on the search form where the source is a field in the table I'm trying to search. The form works great except for the combo box. I pull the data from my table (storing the value rather than the ID), but once I hit my search button, no records are found. This field in my table is...

Microsoft Access / VBA

1543

Help with combo box

by: Don Sealer | last post by:

I have a form that is based on a table called CVA Defects Table. Three of the fields in the table and form are Oil line defects, Gas line defects, and Sub assembly defects. These fields use lookups into another table called "defects table". If I input from the CVA Defects Table everything works fine all the time. However when I input data from the form I have problems. The Oil & Gas line lookups work very well all the time in the form....

Microsoft Access / VBA

6947

Pull data from a database to fill combo box.

by: Jeremy Dillinger | last post by:

I have a program setup to pull data from a database. My database table has things such as (category, Item, price, etc.) In my program I want to have multiple list boxes that will have a pull down list of different categories. The category is stored as a number and the item is stored as a string. Also once the item is picked from the list I would also like to extract the price corresponding to the chosen item. This program will be to...

Visual Basic .NET

3058

Multiple combo boxes - got 2 out of 3 working...

by: visionstate | last post by:

Hi there, I am working on a form that uses 3 text boxes and 3 combo boxes. When any data is entered into any of these, I click a command button and this requeries a sub query in the form and displays data dependent on what has been typed in. After having trouble with populating my second combo box (I eventually populated it by putting the fields for both combo boxes in 1 separate query) I am now having problems with the 3rd one and am...

Microsoft Access / VBA

3674

updating subform via selection of combo boxes

by: Dave | last post by:

I want to put the information that the user selects in my combo boxes into a subform that lies on the same form as the combo boxes. Thanks for your help already, Dave

Microsoft Access / VBA

2908

Query Drive Combo Box not displaying query results

by: Del | last post by:

Hello and thanks for any and all assistance! I have a database that is used by several users on several different machines. The backend database is housed on a file server. Each user has a front end on their local machine. The main form of the database has several query driven combo boxes. These queries pull data from the back end database to populate the combo boxes.

Microsoft Access / VBA

8290

Changing the language in Windows 10

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

Windows Server

8815

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8708

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

7307

AI Job Threat for Devs

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...

Career Advice

6161

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5622

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4149

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

4294

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1596

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General