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

Creating a VBA button which adds additional pages to existing form

P: 2
I have been tasked with modifying an existing basic contact database to also hold real estate data on all future contacts entered into the database. So far I have been able to set up the two tables: contact, real estate and connect them via proper Ids and relationships.

My entry form has multiple pages that are "tabbed" for lack of a better phrasing, the first "tab" is basic contact information and the second "tab" is designed to hold information on one property, here is my question.

How do I create a vba based button that "on click" will add additional blank real estate pages to the contact's form to enter additional real estate data? I want to be able to pull up a contact and be able to review all of his/her real estate currently owned.
Apr 14 '10 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,769
This looks like an example of wanting to over-engineer.

I suggest you design the form where such data is displayed simply to allow for multiple records. Even in Single Form view you can navigate between records as long as Record Selectors are enabled.
Apr 15 '10 #2

P: 2
Yes, I understand this is a text-book example of over-engineering. I am just trying to keep it simple for the end user and this was my initial idea.
Apr 15 '10 #3

Expert Mod 15k+
P: 31,769
Do you think my suggestion would work for you?

Within that structure you could more easily fit in code to keep things simpler for the users should you wish. Separate pages would not be easy to implement.
Apr 15 '10 #4

Post your reply

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