Creating a Form

[Parra]

I think this Access Forum is just what I needed. I need to create what to me is a complicated form.

I have 3 tables: Date, Section & Page Count

Date inludes (Date, Day of Week)
Section includes (List of 15 Possible Sections)
Page Count includes (Date, Day of Week, Section, Page Count)

I want to create a Form to populate the Page Count Table.

So I need the Date will be chosen from the Date Table
Day of Week will be determined by the date chosen
I need all 15 Sections in the table to appear with a blank column next to it so the user can input the page count.

I tried to make this as brief as possible, but I really need some help cause I have tried all afternoon and have gotten no where, and I want to leave for happy hour!

Thanks for your help
Parra

 

[Anne Troy]

Create a query with both Page Count and Section tables.

When you make a form from this query (using wizard), it should ask you if you want section or page count form, tell it page count. This should give you a page count form with a subform of sections.

Create an Order Entry DB that comes with Access to see a similar form.