Inputing of info inside selected data

[Guest]

I have created a drop down in my table which allows me to choose Paragraph
1,2 or 3 (see below) and then I need to ask for the relevant information
required by the selected paragraph and this is where I'm stuck!!!

My user needs to select one of the paragraphs and then depending on which
one is selected, they then need to fill in additional information, as
follows:-

PARAGRAPH1
'Property' means the immovable property described as [insert full property
description] and includes all buildings on and improvements to the Property,
and 'Properties', if more than one, is to be construed accordingly;

PARAGRAPH2
'Property' means a sectional title unit consisting of section number [insert
number] in the sectional title scheme known as [insert name in full] together
with an undivided share in the common property of such sectional title scheme
and includes, where applicable, any right of exclusive use, and 'Properties',
if more than one, is to be construed accordingly;

PARAGRAPH3
'Property' means the Borrower’s entire right, title and interest in and to
the notarial deed of lease entered into between [insert full name and
identity or registration number of landlord] and the Borrower in respect of
the immovable property described as [insert full property description], and
'Properties', if more than one, is to be construed accordingly;

Any and all help is GREATLY appreciated

Regards,
Rene

 

[strive4peace]

Hi Rene,

use a FORM to input data into your table. That is where you
want to define the lookup, not in the table design. You can
then use the AfterUpdate event of a control to determine
what to do.

Don't use lookup fields in table design
http://www.mvps.org/access/lookupfields.htm


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Guest]

This answer will only get you part way there, but here it is anyway:
I would set up a table for each paragraph (Par1, Par2, and Par3) having just
an autonumber field and fields for the inputs for each paragraph. For
example, my Par1 table included just Par1ID and the field FullDescription.
Then, I'd make queries based on those tables to complete your paragraphs.
Here is the SQL from my Par1Qry:

SELECT Par1.Par1ID, Par1.FullDescription, "'Property' means the immovable
property described as " & [Par1]![FullDescription] & " and includes all
buildings on and improvements to the Property,
and 'Properties', if more than one, is to be construed accordingly;" AS Par1
FROM Par1;


At this point, you could make forms based on these queries and have your
listbox be a control for which form to open.

 

[strive4peace]

Hi Rene,

With all due respect, I would suggest putting each of the
paragrahs into the SAME table structure -- you could have
another field that numbers the paragraphs.

Otherwise, what Anne suggested about seperating the
paragraphs is a good idea. You would have an AutonumberID
that is the primary key. You would also have a Long Integer
field to act as a foreign key so you could match the
paragrahs with where they belong, as well as an integer
ParaNo field.

The main record would be displayed on a form. Then, you can
use a continuous subform to display the paragraphs for the
main record.

To fill the additional information, you could have a
seperate subform control on the main form and swap the
SourceObject to collect the pertinent data.

Do you understand how to use LinkChildFields and
LinkMasterFields? For the second subform, you would have a
calculated control on your main form to use for its
LinkMasterFields.

Post back if you need any clarification.

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*