Duplicating a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Red Lorakeet - 31 Jul 2007 10:14 GMT

I've already got a form set up in access. Works fine.

Due to various people changing their mind over things - what's new there
then I need to create an additional form.

It will be exactly the same as the existing one but the data will come from
a different query, the fields will all be the same. I have to use a
different query as I have to change some of the existing data.

Basically it's a case of I wouldn't start from here but I'm stuck with it.

there must be an easy way please?

Only an access novice. Detailed assistance please if possible.

Reply to this Message

Allen Browne - 31 Jul 2007 10:36 GMT

1. In the Database Window, on the Forms tab, click on the form you want to
duplicate.

2. Copy (Ctrl+C), and paste (Ctrl+V.)
Access will ask you for the name for the new form.

3. Open the new form in design view.
Change its Record Source property to the new data source.
(It's the first item on Data tab of Properties box, when looking at the
properties of the form - not of a text box.)

If you are okay with writing code, you may not need the extra form. It may
be possible to set the form's RecordSource property programmatically, or to
use the form's Filter and FilterOn (or OrderBy and OrderByOn) properties
instead of changing the query.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I've already got a form set up in access. Works fine.
>
[quoted text clipped - 10 lines]
>
> Only an access novice. Detailed assistance please if possible.

Reply to this Message