By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,544 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Relation

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.