Cascading comboboxes does not work in a subform

111 100+

I have a table called tblLocationInfo which has field like

ID, PK, autonumber
intRptId, fk
intCountyID
intTownshipID
intQuadID

I have a form which has a subform and this subform has all these county, township and quad comboboxes based on the look up tables(ex tblCounty,tblTownship and tblQuad).
When I run the subform alone, it works fine but when I put inside my main form it asks me to enter
[forms]![frmSubLocation]![cmbCounty] .
This is because the quad and township depends on the county selected.
So in the queries of the comboboxes has criteria like

CountyID=[forms]![frmSubLocation]![cmbCounty]

It does not get the value from the County combobox in the subform I think.
I need help fixing this.
Thanks much!!

Feb 15 '10 #1

Subscribe Post Reply

✓ answered by RuralGuy

See if this link helps a bit. http://www.mvps.org/access/forms/frm0031.htm

2477

RuralGuy

375

Expert 256MB

See if this link helps a bit. http://www.mvps.org/access/forms/frm0031.htm

Feb 15 '10 #2

AccessBeetle

111

100+

I think I got the fix.
Thanks this doc. really helped

Feb 15 '10 #3

RuralGuy

375

Expert 256MB

You're welcome. Glad I could help.

Feb 15 '10 #4

Similar topics

Enter New Data In Comboboxes Only

by: Kathy | last post by:

In my custom menu one menu item opens a form to add new Makes to TblMakes and another menu item opens a form to add new Models to TblModels. I have a form that has a combobox for Makes and a...

Microsoft Access / VBA

ComboBoxes on Subform don't display value until one is clicked.

by: johnson_cy | last post by:

I am using Access 2000. My main form has a record source of a table (employeeTbl with key of . It is filtering the record results. My subform and mainform have the link child/link master set...

Microsoft Access / VBA

cascading combo-boxes and data structure

by: cognoscento | last post by:

I'm currently putting together a database for my work (not an expert by any stretch, so muddling through as best as I can... you know the story...) and I could use some advice and hand-holding ...

Microsoft Access / VBA

Cascading lists problem

by: visionstate | last post by:

Hi there, I am building a database that requires cascading lists on a form. I currently have (I may be adding more later) 3 combo boxes on my form - Department, Surname and Forename. The user...

Microsoft Access / VBA

Access 97 Multiple columns [comboboxes] on single subform

by: Major Doug | last post by:

Hello: situation--I have a research database. Each record in the database consists of 10 fields. I used access97 to rack/stack my database; very easy in the beginning. I created a form with a...

Microsoft Access / VBA

connecting comboboxes in a subform

by: Mike | last post by:

Hi guys, i have a form(myform) where i connected a pair of comboboxes for managers and supervisers, so when you choose a manager the second combo shows only those supervisors who report to him....

Microsoft Access / VBA

Cascading Combo Boxes not seeing info in previous boxes

by: klarae99 | last post by:

Hello, I am working on an Access 2003 Database. The tables that pertain to this issue are tblOrg, tblState, tblCity, and tblZip. I have posted the table structure with only the pertinant fields...

Microsoft Access / VBA

Whats wrong with my Cascading Combo Code

by: azalea45 | last post by:

Hi all I am a newbie when it comes to access. My company requires that all Databases run on the company SQL back-end as a result i have a Access project that connects to the server. I have two...

Microsoft Access / VBA

Cascading ComboBoxes

by: Tarheel | last post by:

...You're fast! I appreciate that. Thanks! I look forward to your explanation. One last problem I have on my form is getting all of my comboboxes to update each other. I know how to update...

Microsoft Access / VBA

Using comboboxes in a form works, however when placed in a subform they have errors.

by: fenners | last post by:

Hi new to programming VBA in Access 2003. I have a form which has two comboboxes. The first combobox uses the folowing rowsource. SELECT Outputs_Classification.Output_id,...

Visual Basic 4 / 5 / 6

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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

General

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

C / C++

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

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

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

Networking - Hardware / Configuration

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