Copying a bound form

[mate]

hey all,

I have a form based on a query. I want to create 5 or so
other forms that are based on different queries. However
i really like the design of the first original form and it
would be almost impossible to replicate by hand. Is there
a way to copy the design of the original form and than
apply it to the new queries? Any help would be greatly
appreciated. Thanks, mate.

 

[Gary Miller]

You can copy a form in the database window and then paste it
back giving it a new name. Now you can just change the
datasource for the new copy.

The more accepted method, however, is to use the same form
and just open it with the same recordsourse, but use the
Where condition of the OpenForm method to specify the
records that you want to see displayed in the form. Check
out OpenForm in Help. This saves you from having to have a
separate form for each situation you may run into.

Gary Miller