One form(as a template) to many tables with same fields

  • Thread starter 1 form for similar table
  • Start date
1

1 form for similar table

i have to build a form which is built purposely for data entry. So i need the
form(masterpiece) to become a template for other tables which have the same
fields. For eg: i got tblWEEK01,tblWEEK02,tblWEEK03 all with the same fields.
In week01 i will enter data into tblWEEK01 using FORM(masterpiece) and in
week02 i will do the same thing to enter data into tblWEEK02 with the same
FORM(masterpiece)

So in other words, the FORM that i created become the template for all the
similar table, can i know how can i do it? i only manage to enter data into
tblWEEK01

Urgent, thanks for the help...
 
L

Larry Linson

Almost certainly, from your description, your database is unnormalized and
violates good relational database design practices -- immediately visible by
the fact that the table (names) themselves are part of the data. I'd suggest
you reconsider that table design, and replace all the separate tables with a
single one, with a data field that identifies the week. In the long run, it
will save you mental trauma and grief.

That said, if each of the tables has the same fields, you can set the
RecordSource of the Form in its Open event, or use the Filter argument of
the DoCmd.OpenForm statement to override it. That RecordSource will
determine where the form gets its data.

Larry Linson
Microsoft Access MVP




"1 form for similar table" <1 form for similar
[email protected]> wrote in message
news:[email protected]...
 
Top