Hello,
Well, after an initial review of my database by my client, they have
completely changed their minds about how they want their form. As a
result, I'm having to re-think the whole process.
My Current Form (6 tabs):
- Owner, Property, Title, Docs, Queries, & Reports
- User is able to see (while navigating through the tabs) above in the
form : Owner Name, Address, Parcel, and SSN
The New Form (3 tabs):
TAB 1 - Owner, Property, Title, and Docs combined, to be "Dynamic"
TAB 2 - Queries
TAB 3 - Reports
- User is able to see (while navigating through the tabs) above in the
form : Owner Name, Address, Parcel, and SSN
The "Dynamic" requirement is due the fact that NOW my clients want to
cover ALL the possible ownership scenarios for this project, which is
now about 15 possible combinations. Some examples of ownerships are a
single owner, multiple owners, co-owners (like investors), 1/2 company -
1/2 private, and on and on.
My idea is to write an event procedure that, when the user clicks on TAB
1, an "OnClick" event, a procedure is called to load a dialog with 15
possible (of the aforementioned) options, and based on the user's
selection, loads the respective form. An example of the dialog would
be:
Form 1: Parcel is Separate Property (Male Lessor)
Form 2: Parcel is Separate (Female Lessor)
Form 3: Parcel is Separate (Multiple Lessors)
Form 4: Parcel is Community Property (Male Lessor)
Form 15: Parcel is under Power of Attorney
etc...
or "Cancel"
Lessor = Owner.. BTW
Questions:
1 - First off, am I going in the right direction? Should I do this
another way? Is there a more *simpler* way to do this? Instead of a
dialog, should I have a form to call any one of the 15 forms?
2 - Assuming I AM going in the right direction, then, would you do this
with Select Case, or what?
3 - If YES on #2, what will be the code for it? If NO on #2, what would
be the code for the NO answer?
4 - Originally, my form was from 1 table, now it will be 3 tables. They
will be tblOwner, tblParcel, and tblOwnerhips. Will I be able to get the
dynamic form to send data to ALL 3 of the tables? Or will I need to
create sub-tabs in the dynamic form to handle the data to each table?
I'm WAY lost on this one, so please bear with me!
5 - Let's say for ease of discussion, that if my question #4 is way off,
assume that I'll be working off of 1 table, if that helps you to explain
better the dynamic portion. I'll figure out someway to get everything
on 1 table, I guess.
I hope that I've explained this well enough, but if you need more info,
please let me know. I'm going to need to crunch this out over the
weekend (fun...). So I'm anxious to hear what you all have to say.
TIA.
Phil.
Well, after an initial review of my database by my client, they have
completely changed their minds about how they want their form. As a
result, I'm having to re-think the whole process.
My Current Form (6 tabs):
- Owner, Property, Title, Docs, Queries, & Reports
- User is able to see (while navigating through the tabs) above in the
form : Owner Name, Address, Parcel, and SSN
The New Form (3 tabs):
TAB 1 - Owner, Property, Title, and Docs combined, to be "Dynamic"
TAB 2 - Queries
TAB 3 - Reports
- User is able to see (while navigating through the tabs) above in the
form : Owner Name, Address, Parcel, and SSN
The "Dynamic" requirement is due the fact that NOW my clients want to
cover ALL the possible ownership scenarios for this project, which is
now about 15 possible combinations. Some examples of ownerships are a
single owner, multiple owners, co-owners (like investors), 1/2 company -
1/2 private, and on and on.
My idea is to write an event procedure that, when the user clicks on TAB
1, an "OnClick" event, a procedure is called to load a dialog with 15
possible (of the aforementioned) options, and based on the user's
selection, loads the respective form. An example of the dialog would
be:
Form 1: Parcel is Separate Property (Male Lessor)
Form 2: Parcel is Separate (Female Lessor)
Form 3: Parcel is Separate (Multiple Lessors)
Form 4: Parcel is Community Property (Male Lessor)
Form 15: Parcel is under Power of Attorney
etc...
or "Cancel"
Lessor = Owner.. BTW
Questions:
1 - First off, am I going in the right direction? Should I do this
another way? Is there a more *simpler* way to do this? Instead of a
dialog, should I have a form to call any one of the 15 forms?
2 - Assuming I AM going in the right direction, then, would you do this
with Select Case, or what?
3 - If YES on #2, what will be the code for it? If NO on #2, what would
be the code for the NO answer?
4 - Originally, my form was from 1 table, now it will be 3 tables. They
will be tblOwner, tblParcel, and tblOwnerhips. Will I be able to get the
dynamic form to send data to ALL 3 of the tables? Or will I need to
create sub-tabs in the dynamic form to handle the data to each table?
I'm WAY lost on this one, so please bear with me!
5 - Let's say for ease of discussion, that if my question #4 is way off,
assume that I'll be working off of 1 table, if that helps you to explain
better the dynamic portion. I'll figure out someway to get everything
on 1 table, I guess.
I hope that I've explained this well enough, but if you need more info,
please let me know. I'm going to need to crunch this out over the
weekend (fun...). So I'm anxious to hear what you all have to say.
TIA.
Phil.
Comment