Relation - Microsoft Access / VBA

Lasse

Hi
In my Access database I have among others 2 tables.

One with Countries (include 1 row with country) and
another with regions (include 2 row -> Region + Country)

I have made a relation between those two tabels with country, and it seems
fine so far.

My problem is, that I can't find out, how to specify in my form, that I only
regions for a selected country may be shown in the combo box.

Can anybody help ?

wkr
Lasse

Nov 12 '05 #1

Subscribe Post Reply

1343

Sald

Lasse wrote:

Hi
In my Access database I have among others 2 tables.

One with Countries (include 1 row with country) and
another with regions (include 2 row -> Region + Country)

I have made a relation between those two tabels with country, and it seems
fine so far.

My problem is, that I can't find out, how to specify in my form, that I only
regions for a selected country may be shown in the combo box.

Can anybody help ?

wkr
Lasse

I suppose you have a field or combo called Country and a combo called Region.
In the after update event of Country enter
Me.Region.Requery

If your form is called YourFormName, open up the rowsource in the query builder
and in the criteria row enter
Forms!YourFormName!Country

When you requery Region, it looks for the value in the Country field/combo.

Nov 12 '05 #2

Similar topics

db design - the mythical 1:1 relation ?

by: Andreas | last post by:

Hi folks, how would you design a 1:1 relation ? I'd like to split an entities's attributes because they won't get equally frequently requested. So I can save memory and disk access time....

MySQL Database

relation vs table...

by: Terrence Brannon | last post by:

I don't know what Postgres considers a relation and had no intention of creating one when piping my schema to it... I always DROP TABLE before CREATE TABLE, so here are the ERRORS emitted when...

PostgreSQL Database

DDL syntax for dropping relation

by: deko | last post by:

ALTER TABLE DROP CONSTRAINT ; Is this syntax correct? The error I'm getting is: Error Number 3199: Could not find reference. I tried it without the curly braces, but no luck.

Microsoft Access / VBA

Dual Combo box binding problem (relation involved)

by: Brian Henry | last post by:

Here's an example of the code.. I have two combo boxes on screen that when one's selection is change the other's items will be updated to reflect the change (based on a relation) Private...

Visual Basic .NET

DataSet, Relation, IsNested and WebService

by: Corno | last post by:

Hi all, If I want to provide a typed dataset from a webservice and if that dataset has relations that are nested (isNested=True), then the relations(keyrefs) are not available in the XSD that is...

.NET Framework

cache lookup of relation 165058647 failed

by: Juris Krumins | last post by:

I have a problem with postgresql tables. periodicaly, I would say frequently about 5-10 time per hour i have such errors in my server log file: 2004-04-14 12:23:32 ERROR: cache lookup of...

PostgreSQL Database

Parent-Child Relation in DataGrid

by: Ambica Jain | last post by:

I have a data grid called Files, which has some columns like FileName, Col1, Col2, ... , Col8. Then i have a combobox which allows user to select from Col1 to Col8 and based on this selection, i...

C# / C Sharp

Create DataSet relation with more than 1 field

by: Tim Kelley | last post by:

I have two tables that are linked by 2 fields (ID1 and ID2). Is it possible to create this relation once the tables are in a DataSet? I can create a relation using a single field, but I don't...

C# / C Sharp

Getting ID's to insert into a relation table for a "many to many" relation - MySQL

by: bugboy | last post by:

I'm inserting a new word into table 'w' and a definition into table 'c' which are linked in table 's' which is the relation table for the many to many relationship between 'w' and 'c'. I've been...

PHP

Table Relation

by: Miro | last post by:

VS2008 I have created 3 tables. Vendors Customers PhoneNumbers each have their own key Vendor has: VendorID - int unique identifier Customer has: CustomerID - int unique identifier

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

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

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

Windows Server

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

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

Career Advice

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

Microsoft Access / VBA