Access Forms

[ccsionline]

I have a table created in access. I then used the form wizard to create a form to look like I wanted it to.

I now have a new table that has the exact layout as the first. I would like to create a form that uses the data from this table, but looks exactly like the last form I created. I can do this manually, but it does take quite a bit of time. This needs to be done once a month so you can see the time issue that it could cause. Any help is appreciated!

Dave

[MikeTheBike]

I have a table created in access. I then used the form wizard to create a form to look like I wanted it to.

I now have a new table that has the exact layout as the first. I would like to create a form that uses the data from this table, but looks exactly like the last form I created. I can do this manually, but it does take quite a bit of time. This needs to be done once a month so you can see the time issue that it could cause. Any help is appreciated!

Dave

Hi Dave

Not sure why this is necessary (obviously!) or the business logic, if any, but two ways spring to mind.

1) Make a copy of the form (Save As in design view) and then change the record source to the new table.

2) Just change the record source to the new table using code, behind a button or some other logic ?

This is based on the tables being identical except for their names!


MTB

[Scott Price]

I have a table created in access. I then used the form wizard to create a form to look like I wanted it to.

I now have a new table that has the exact layout as the first. I would like to create a form that uses the data from this table, but looks exactly like the last form I created. I can do this manually, but it does take quite a bit of time. This needs to be done once a month so you can see the time issue that it could cause. Any help is appreciated!

Dave

Copy and paste generally works for forms too. Just reset the record source to your new table...

However, a little change in your program flow may quite easily do away with the need to duplicate your tables, forms etc once a month.

Regards,
Scott

[Scott Price]

Sorry Mike!

I opened this post, then went to another before coming back to reply! Didn't realize you had already gotten to it.

Regards,
Scott

[ccsionline]

Copy and paste generally works for forms too. Just reset the record source to your new table...

However, a little change in your program flow may quite easily do away with the need to duplicate your tables, forms etc once a month.

Regards,
Scott

To both of you who have answered:

Thank you so very much! It is great to have help when you are in need and you folks have certainly come through.

The record source change (i didn't know where to go, but a quick "MS. Help" search indicated what to do) works great.

Thanks again,

Dave