In message <48A1CBB8.72ECB121@sizefit827263653ter.com>, johannes <johs@sizefit827263653ter.com> writes Cynic wrote: On Tue, 12 Aug 2008 18:06:22 +0100, johannes <johs@sizefit827263653ter.com> wrote: As you have read the whole thread, you would see that I agree with the principle that self harm should not be illegal. However, the trafficking and distribution

Steven, you can use the same subform on more than one form as long as only one of the main forms is open at the same time. Build a new search form with the 3rd combo, use the same subform. You may need to put code on its BeforeInsert event, to cancel the insert to prevent users adding new records, and set its allow edits to false to stop users changing the data. It's just as easy to

Steven, I'm not fully understanding the problem. Maybe your subform has its Default View property set to Single Form?, if you change this property to datasheet or continuous forms, it will show all the publications for a particular subcategory. Jeanette Cunningham "SJW" <SJW@discussions.microsoft.com> wrote in message news:B36E4DF2-6AF5-4054-936B-BD2D5D39EC3D@microsoft.com...

Steven, I will detail how I used the form wizard as I think it's the easiest way for someone getting started with setting up forms. the first wizard step, choose only 2 of the tables --choose tblSubcategories, choose SubcategoryID and Subcategory --choose tblPublications, choose PublicationID and Publication See if this choice allows the 3rd wizard option Jeanette Cunningham "SJW"

SJW, most likely, its the way you have set up your tables that stops the form wizard from showing the 3rd option that you need. Let's check how you have set up your tables I did this with the tables set up like this: --tblCategories ... --CategoryID Primary Key --Category --Other fields for Category info --tblSubcategories ... --SubcategoryID Primary Key --Subcategory --Other