By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,975 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

Access Forms

P: 2
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
Sep 18 '07 #1
Share this Question
Share on Google+
4 Replies


Expert 100+
P: 634
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
Sep 18 '07 #2

Scott Price
Expert 100+
P: 1,384
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
Sep 18 '07 #3

Scott Price
Expert 100+
P: 1,384
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
Sep 18 '07 #4

P: 2
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
Sep 19 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.