Cadsoftw, Even easier, after you copy the table and complete the first form: 1) in the form designer, right-click on the already completed form: 2) choose "copy" 3) in the dialog, change the table name for the new copy of the form to the second table
Bill On Tue, Jun 30, 2009 at 9:45 AM, <[email protected]> wrote: > Here is a nice tip: > > Suppose you'd like to have two table with the same structure but > different names, > two forms one for each table that look exactly (or almost the same), > and you alreayd coded one of them. How do you create a second form with > minimal efforts. > > Answer: > > 1. Copy the table. > 2. Use form wizard to create second form against the second table, > delete all controls of the second form. > 3. copy the entire database to backup(just copy files) > 4. Open original(prototype) form in backup database. > 5. In form designer do "select All" , "copy", paste result in the > Notepad > it will look aproximately liked this: > > 6. So it is a text file, use Notepad Replace command to change the > table name > to new table name, copy the result from notepad and paste it in a new form. > >
