adapting forms from templates

[Guest]

I have downloaded a contact mamagement database template from the microsoft
website and want to use the form design for my own database.

I have created the tables and established the relationships but cannot get
the subforms to work in the same way.

There is a main form which includes 2 subforms based on a Calls Table.
Primary key in the calls table is call ID, tables are related by ContactID in
the Contacts table.

The first subform contains 3 fields and is in datasheet view

The second subform (which appears to act as part of the 1st subform)
contains a notes field and is in single form view.

I have checked the form properties of both subforms and the differences are
the default view settings and that the second subform has the Record
Selectors property set to No. The Link Child and Link Master Fields are set
to ContactID in the 1st subfrom and CallID in the second subform but I don't
know how to change this.

I have no previous programmming or code writing experience but really want
to be able to use this form.

Any help (simply expalined) would be appreciated

Jane

 

[Guest]

Open the form in design view and open the properties box (right click).
Click the subform (the top lefthand square) and then on the data section on
the properties box ensure the link child and master field are the same.

Hope this helps

 

[Guest]

Thanks for the response but when I checked these fields in the 2 subforms
they were different from each other.

In the Calls Details Subform both Link Child and Link master fields were set
to CallID whereas in the Call Listing Subform (the one with 3 fields) they
were both set to ContactID

Hope this makes sense.

Jane

 

[Guest]

Link the 1st subform to the main form (child and master) using contactID

Then link the 2nd subform to the 1st using either the same ID or create a
field in the source table (where the 2nd form is taken from ) and use this to
form the link.

Ensure that any field you try to use or of the same data type.

The easyist (and best) way would to be to look at the relationship sheet and
use the field that are linked on that (as this way at least you know it
works).

 

[Guest]

What I did originally was to downlad the template from the Microsoft website
-Access templates/Business/Contact management database. Then I deleted the
forms and tried to re-create them myself using the current tables and
relationships that had been created.

I have explored the forms in great detail and produced copies of the
property details and tried to follow them but I am still struggling on this
last bit.

Perhaps, if you are willing, you could look at the database on the website
because I may not be explaining myself clearly enough and it might clarify
what I mean.

Thanks in anticipation

Jane

 

[Guest]

Hi Jane you seem to be having a few problems. No worries. If the d base
came from the ms site then it should be ok.

If you still have the main table/querries that you downloaded (if not then
download them again).

Then - if you're not too sure about createing forms and subform don't worry
as there is a wizard just for this.

Single left click the query that will act as the source for the main form
then click the "NewObject"AutoForm Button) it's at the top of the page.

Then simply click the fields you want in your main form. Once you have done
this (don't come out of the wizard) use the slider on the right of the query
names list to selct the source of your 2nd (sub)form and then select the
field for this. Do the same for the 2nd (sub) form.

Next you will have the option to see how the forms will look like. If
you're not happy with the results simply close without saving and run the
wizard agaain.

Hope this helps

 

[Guest]

Sorry I made a mistake on that - it should read

Then simply click the fields you want in your main form. Once you have done
this (don't come out of the wizard) use the slider on the right of the query
names list to selct the source of your "1st" (sub)form and then select the
field for this. Do the same for the 2nd (sub) form.

 

[Guest]

Hi Wayne

Thought I'd nearly done it then.

I followed your instructions to create the main form and subform (although
they are based on tables not queries).

The problem then is that the 2nd subform is based on the same table as the
first.

What I did then was I created a subform within the 1st subform which seemed
to work except that I can only view the data by clicking the subdata sheet
button in datassheet view on the 1st subform.

in the template that I downloaded the 2nd subform appears almost as part of
the 1st and when you highlight a row in the datasheet view of the 1st form
the data appears in single form view in the 2nd subform below (if any of that
makes sense).

Thanks for being so patient!

Jane