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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top