subform new records

[Guest]

Im using Access 2000. I have a form based on a multi-table query. I am using
Tab Control to show multiple tabs. All my tables are linked with RI and
Cascading. I'm using a unbound combo box to select the record for the main
form. One of the tabs i added a subform based on a table that is linked to a
PK (clientNum) One-to-Many relationship. I've tried adding the subform based
on the table name (tblInsurance), a query (which includes the PK and FK) but
i cant get the subform to update the FK field in the subform when i add a new
record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

 

[ruralguy via AccessMonster.com]

Access will only update the LinkChild/MasterFields in a new record in the
SubForm but you can specify more than one field by separating then with a
semi-colon ";". They must be in the same order as well.

Im using Access 2000. I have a form based on a multi-table query. I am using
Tab Control to show multiple tabs. All my tables are linked with RI and
Cascading. I'm using a unbound combo box to select the record for the main
form. One of the tabs i added a subform based on a table that is linked to a
PK (clientNum) One-to-Many relationship. I've tried adding the subform based
on the table name (tblInsurance), a query (which includes the PK and FK) but
i cant get the subform to update the FK field in the subform when i add a new
record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

 

[Guest]

when i add a new (first) record in the subform, the FK is not automatically
filled in.
It is included in the subform. I wish to add multiple records as well and
each time the FK should be auto populated. Should i use a subform based on
the table or a query. My undersanding is the FK should auto populated so as i
start type in one of the fileds in the subform.

Access will only update the LinkChild/MasterFields in a new record in the
SubForm but you can specify more than one field by separating then with a
semi-colon ";". They must be in the same order as well.

Im using Access 2000. I have a form based on a multi-table query. I am using
Tab Control to show multiple tabs. All my tables are linked with RI and
Cascading. I'm using a unbound combo box to select the record for the main
form. One of the tabs i added a subform based on a table that is linked to a
PK (clientNum) One-to-Many relationship. I've tried adding the subform based
on the table name (tblInsurance), a query (which includes the PK and FK) but
i cant get the subform to update the FK field in the subform when i add a new
record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

Is your [ClientNum] populating in the SubForm when you add a new record?
What other key did you want populated? Have you coded your
LinkChild/MasterFields with [ClientNum];[OtherKey]?

when i add a new (first) record in the subform, the FK is not automatically
filled in.
It is included in the subform. I wish to add multiple records as well and
each time the FK should be auto populated. Should i use a subform based on
the table or a query. My undersanding is the FK should auto populated so as i
start type in one of the fileds in the subform.

Access will only update the LinkChild/MasterFields in a new record in the
SubForm but you can specify more than one field by separating then with a

[quoted text clipped - 9 lines]

record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

 

[Guest]

No [clientnum] is not auto populating on the subform. All all other fields
are manually filled in. Yes Child/MasterFields have ClientNum filled in. Join
Property on the tblclient and tblinsurance Relationship is option 1.

Is your [ClientNum] populating in the SubForm when you add a new record?
What other key did you want populated? Have you coded your
LinkChild/MasterFields with [ClientNum];[OtherKey]?

when i add a new (first) record in the subform, the FK is not automatically
filled in.
It is included in the subform. I wish to add multiple records as well and
each time the FK should be auto populated. Should i use a subform based on
the table or a query. My undersanding is the FK should auto populated so as i
start type in one of the fileds in the subform.

Access will only update the LinkChild/MasterFields in a new record in the
SubForm but you can specify more than one field by separating then with a

[quoted text clipped - 9 lines]

record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

Hmmm, something is amiss. Try importing everything into a new, empty mdb and
see if the results are the same. It only take a few seconds and might get
things working again.

No [clientnum] is not auto populating on the subform. All all other fields
are manually filled in. Yes Child/MasterFields have ClientNum filled in. Join
Property on the tblclient and tblinsurance Relationship is option 1.

Is your [ClientNum] populating in the SubForm when you add a new record?
What other key did you want populated? Have you coded your

[quoted text clipped - 12 lines]

record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

 

[Guest]

How do i important in seconds?
Should i be using a query for the subform? should the FK be indexed or not?
Im using a comb box on the main form to display the data and its not picking
of the FK record with i get to the tab with the subform. What should the
record source be for the FK in the subform? It doesn't have one now? Do i
have to automate (sync the subform with the the PK) this function or should
it happen automatically. Im grasping?

Hmmm, something is amiss. Try importing everything into a new, empty mdb and
see if the results are the same. It only take a few seconds and might get
things working again.

No [clientnum] is not auto populating on the subform. All all other fields
are manually filled in. Yes Child/MasterFields have ClientNum filled in. Join
Property on the tblclient and tblinsurance Relationship is option 1.

Is your [ClientNum] populating in the SubForm when you add a new record?
What other key did you want populated? Have you coded your

[quoted text clipped - 12 lines]

record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

I'm sorry Chuck but I thought you had a RecordSource for the SubForm. The
RecordSource of the SubForm should be a query of the table you wish to
display that has the ClientNum in one of its fields as a FK.

How do i important in seconds?
Should i be using a query for the subform? should the FK be indexed or not?
Im using a comb box on the main form to display the data and its not picking
of the FK record with i get to the tab with the subform. What should the
record source be for the FK in the subform? It doesn't have one now? Do i
have to automate (sync the subform with the the PK) this function or should
it happen automatically. Im grasping?

Hmmm, something is amiss. Try importing everything into a new, empty mdb and
see if the results are the same. It only take a few seconds and might get

[quoted text clipped - 9 lines]

record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

 

[Guest]

bingo! thanks - however i had to add the FK manually to the subform (i'm
using a custom Text based PK/FK). I would like this automated as i have a
text box on the same tab with the PK showing. Suggests?

I'm sorry Chuck but I thought you had a RecordSource for the SubForm. The
RecordSource of the SubForm should be a query of the table you wish to
display that has the ClientNum in one of its fields as a FK.

How do i important in seconds?
Should i be using a query for the subform? should the FK be indexed or not?
Im using a comb box on the main form to display the data and its not picking
of the FK record with i get to the tab with the subform. What should the
record source be for the FK in the subform? It doesn't have one now? Do i
have to automate (sync the subform with the the PK) this function or should
it happen automatically. Im grasping?

Hmmm, something is amiss. Try importing everything into a new, empty mdb and
see if the results are the same. It only take a few seconds and might get

[quoted text clipped - 9 lines]

record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

 

[ruralguy via AccessMonster.com]

In order for Access to assist in filling in the FK in the SubForm, the two
fields need to be the same type and specified in the LinkChild/MasterFields
properties of the SubForm Control.

bingo! thanks - however i had to add the FK manually to the subform (i'm
using a custom Text based PK/FK). I would like this automated as i have a
text box on the same tab with the PK showing. Suggests?

I'm sorry Chuck but I thought you had a RecordSource for the SubForm. The
RecordSource of the SubForm should be a query of the table you wish to

[quoted text clipped - 13 lines]

record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

 

[Guest]

the subform control was referencing tblClients.ClientNum, i changed it to
ClientNum and its working now. thanks a bunch!

In order for Access to assist in filling in the FK in the SubForm, the two
fields need to be the same type and specified in the LinkChild/MasterFields
properties of the SubForm Control.

bingo! thanks - however i had to add the FK manually to the subform (i'm
using a custom Text based PK/FK). I would like this automated as i have a
text box on the same tab with the PK showing. Suggests?

I'm sorry Chuck but I thought you had a RecordSource for the SubForm. The
RecordSource of the SubForm should be a query of the table you wish to

[quoted text clipped - 13 lines]

record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

Great Chuck. Glad you got it working.

the subform control was referencing tblClients.ClientNum, i changed it to
ClientNum and its working now. thanks a bunch!

In order for Access to assist in filling in the FK in the SubForm, the two
fields need to be the same type and specified in the LinkChild/MasterFields

[quoted text clipped - 9 lines]

record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.