Thanks Peter for your suggestions.
I have tested the method given in kb 209576 but have failed. Your first
mentioned method and the one given by Jackie Home are too general for me but
the kb being more detailed was easier.
After having typed everything correct in my Swedish edition of Northwind and
Acc2000 and thus no error messages appeard any more the result was that all
Rooms appeared in the the second cbo irrespective of the setting in cboHouse. I
tested both with my own tables and with those in Northwind with equal result.
Under 3. in the kb a Criteria is given that seems to be incorrect. With both
bases I get an error message that tells me that the comma at the end of the
first line is not correct (when trying to save the query the message comes and
the comma is marked. On the other hand the criteria is, I guess, not essential
for the end result, only a way to take care of the situation when nothing is
selected in cbo1.
Do you have any comments on this or could you possibly suggest another method
in some detail, being possible for me use?
Best regards
Ove
----- Original Message -----
From: phoogenb
To: [EMAIL PROTECTED]
Sent: Wednesday, April 11, 2007 4:45 PM
Subject: [ms_access] Re: Form design with choosen records
Hi Ove,
One possible solution: A form displaying tblHouse records, and
containing a subform showing tblRoom records. If you set it up
properly, Access will handle the filtering of the subform automatically.
Something else that might be of use: A pair of combo boxes, where the
user selects a house in the first one, and then the second one shows
only those rooms that belong to the chosen house. There's a
description of how to do this in the MS Knowledge base ("How to Create
Synchronized Combo Boxes"):
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576
Good luck,
Peter Hoogenboom
--- In [EMAIL PROTECTED], "Ove Billing" <[EMAIL PROTECTED]> wrote:
>
> I am not very skilled at Access but try anyway to help a small local
> museum to erect a base with their objects.
> One problem to handle (with simplified examples): I think of having a
> tblHouse with 4 records (H1, H2, H3 and H4) and a tblRoom with many
> rooms (R1, R2 ...), some in H1, others in H2 etc. How do I construct a
> form where only rooms in H1 are visible or choosable when first
> choosing H1 etc. ? Is this possible? Other ways?
>
[Non-text portions of this message have been removed]
