Creating a VBA button which adds additional pages to existing form

[benedeal]

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.

[NeoPa]

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.

[benedeal]

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.

[NeoPa]

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.