I SCREWED UP I NEED HELP WITH A FORM & A TABLE

[chubby]

Okay, I know broke the first rule of thumb in database design. I know I screwed up!!! I developed the forms before I developed my table. Why? Because my boss made such a big deal out of having these forms look just like the word document we’re currently using. (We’ve been using this form for months if you get my hint!!!) So I spent hours designing the darn things and he loves them. Now I want to attach forms their tables. Is there an easy way of doing this? Right now, I'm cutting and pasting from my already made forms onto a blank form that has the underlying table on it. Killer part is going unbound box by unbound into the properties and change the control source option for unbound box. (41 fields to change)

What I'm asking is can I just attach my Forms to their tables another way. I’m using Access 2000. There are 9 nine forms in all with 9 nines (All the tables are the same but named DS1, DS2, etc…All the Forms are the same but named WB1, WB2, etc… Or is there to make 1 form place information in nine different tables.
And have multi-users track their information but for there section only.

Thanks

 

[BoxHead]

Not sure if I'm reading this right, but if the field names are the same from table to table, you should be able to change the record source for the form.

If you really want to have nine different forms, you could link the fields in the first and then copy the form eight times. Go back into the copies and update the RecordSource property for the form itself.

HTH

John

Use what you have,
Learn what you can,
Create what you need.

 

[chubby]

Thanks, it worked... I'm in your debt..