First you need to construct a query to pull just the H1 records then you can design a for to display them.
When we come to the edge of the light and are about to step off into the darkness of the unknown, we can be sure ... either God will provide something solid to stand on or ..... we will be taught to fly. _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ove Billing Sent: Wednesday, April 11, 2007 5:37 AM To: [email protected] Subject: [ms_access] Form design with choosen records 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? -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.0.0/754 - Release Date: 4/9/2007 10:59 PM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.0.0/754 - Release Date: 4/9/2007 10:59 PM [Non-text portions of this message have been removed]
