Can 1 form be used for entering data into many tables

[1ooo1]

Hi,
I am trying to make an employee leave roster.
I have 12 tables, 1 for each month, 1 column with employees and 1 column for each day of the month. Is it at all possible to use 1 form to enter data into any of the tables depending on which month an employee requires leave, or do I have to have a form for each table. The form consists of a ComboBox with an employee list and a TextBox for each day.
Does that make sense?

Ken

 

[930driver]

Before you persue this path I strongly suggest you give your self a bit of education on normalization. Having multiple tables for the same data is going to cause you big problems down the road. You would be better off with one table for your leave information and filter by date as necessary.

I'd recommend you move to the 'Microsoft: Access Tables and Relationships' forum, describe what you need to do (in the data storage sense, not about the forms) and ask for ideas. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"