table linkage and sub forms

Using Access 2003 in XP SP2 ...
I have a simple DB consisting of three tables. All three have a common field
called "Volunteer Number". The primary table is linked to the other two
tables in a one (primary table) -to-many (other tables) relationship.

The data entry form contains a tabbed control consisting of three tabs:
First tab is a continuation of the main form of data that does not need to
remain visible at all times. Second and third tabs are sub forms for each of
the other tables.

These two are continuous forms that by themselves show proper linkage to
their respective tables and display the Volunteer Number.

The primary form uses a query for it's data -- only because I needed to add
a single field in the query for "LastName FirstName" to do a record lookup in
the primary form header.

Once the sub forms were in place I had a very difficult time getting one of
them to progress with the primary form records, though the other form worked
fine. I finally deleted the faulty sub form and created a new one with the
wizard using all the default settings. Then it worked. Great!

Then, using a copy of the working DB (I'm getting smarter) I went in and
edited (shortened) the table names and sub form names. I went into each of
the forms' properties and corrected the Data source tables, and they show the
data in their tables corrrectly. However, now neither of the sub forms are
working properly(progressing with the primary form records) when brought into
the primary form.

I have tried rebuilding one of them as I did before, but this time it didn't
correct the problem. I'm at a loss as to why the sub forms are not linking
properly with the primary form. They show up all right -- they just don't
show the data that's already in the linked tables.

I can use the original DB and simply leave it alone if I must. But if
something were to go wrong with that one also, I wouldn't have a clue how to
fix it because I don't know where the problem lies. It's scary.

Can anyone tell me what I'm doing wrong? BTW, I've tried the old Compact
and repair bit. Also, please note that I've written several DBs using sub
forms and even a sub sub form in the past with no problems.

My sincere thanks to anyone willing to tackle this problem.

--
Norm Shimmel
Butler, PA

I maybe stating the obvious here, but have you checked the Link Child Fields
and Link Master Fields properties of your sub form controls? You don't
mention this anywhere.

"NES" wrote in message
...
Using Access 2003 in XP SP2 ...
I have a simple DB consisting of three tables. All three have a common
field
called "Volunteer Number". The primary table is linked to the other two
tables in a one (primary table) -to-many (other tables) relationship.

The data entry form contains a tabbed control consisting of three tabs:
First tab is a continuation of the main form of data that does not need to
remain visible at all times. Second and third tabs are sub forms for each
of
the other tables.

These two are continuous forms that by themselves show proper linkage to
their respective tables and display the Volunteer Number.

The primary form uses a query for it's data -- only because I needed to
add
a single field in the query for "LastName FirstName" to do a record lookup
in
the primary form header.

Once the sub forms were in place I had a very difficult time getting one
of
them to progress with the primary form records, though the other form
worked
fine. I finally deleted the faulty sub form and created a new one with the
wizard using all the default settings. Then it worked. Great!

Then, using a copy of the working DB (I'm getting smarter) I went in and
edited (shortened) the table names and sub form names. I went into each of
the forms' properties and corrected the Data source tables, and they show
the
data in their tables corrrectly. However, now neither of the sub forms are
working properly(progressing with the primary form records) when brought
into
the primary form.

I have tried rebuilding one of them as I did before, but this time it
didn't
correct the problem. I'm at a loss as to why the sub forms are not linking
properly with the primary form. They show up all right -- they just don't
show the data that's already in the linked tables.

I can use the original DB and simply leave it alone if I must. But if
something were to go wrong with that one also, I wouldn't have a clue how
to
fix it because I don't know where the problem lies. It's scary.

Can anyone tell me what I'm doing wrong? BTW, I've tried the old Compact
and repair bit. Also, please note that I've written several DBs using sub
forms and even a sub sub form in the past with no problems.

My sincere thanks to anyone willing to tackle this problem.

--
Norm Shimmel
Butler, PA

It's not all that obvious. I spent an hour looking for those properties (I
had seen them before) and discovered that I could only see them the first
time I clicked on one of the controls in the sub form, and ONLY immediatly
after going into design view. No help was evident when I looked.

Now I have looked at these and found that both child and master are linked
with the Volunteer Number field.

Thanks for your response. Where do we go from here?
--
Norm Shimmel
Butler, PA


"Baz" wrote:

I maybe stating the obvious here, but have you checked the Link Child Fields
and Link Master Fields properties of your sub form controls? You don't
mention this anywhere.

"NES" wrote in message
...
Using Access 2003 in XP SP2 ...
I have a simple DB consisting of three tables. All three have a common
field
called "Volunteer Number". The primary table is linked to the other two
tables in a one (primary table) -to-many (other tables) relationship.

The data entry form contains a tabbed control consisting of three tabs:
First tab is a continuation of the main form of data that does not need to
remain visible at all times. Second and third tabs are sub forms for each
of
the other tables.

These two are continuous forms that by themselves show proper linkage to
their respective tables and display the Volunteer Number.

The primary form uses a query for it's data -- only because I needed to
add
a single field in the query for "LastName FirstName" to do a record lookup
in
the primary form header.

Once the sub forms were in place I had a very difficult time getting one
of
them to progress with the primary form records, though the other form
worked
fine. I finally deleted the faulty sub form and created a new one with the
wizard using all the default settings. Then it worked. Great!

Then, using a copy of the working DB (I'm getting smarter) I went in and
edited (shortened) the table names and sub form names. I went into each of
the forms' properties and corrected the Data source tables, and they show
the
data in their tables corrrectly. However, now neither of the sub forms are
working properly(progressing with the primary form records) when brought
into
the primary form.

I have tried rebuilding one of them as I did before, but this time it
didn't
correct the problem. I'm at a loss as to why the sub forms are not linking
properly with the primary form. They show up all right -- they just don't
show the data that's already in the linked tables.

I can use the original DB and simply leave it alone if I must. But if
something were to go wrong with that one also, I wouldn't have a clue how
to
fix it because I don't know where the problem lies. It's scary.

Can anyone tell me what I'm doing wrong? BTW, I've tried the old Compact
and repair bit. Also, please note that I've written several DBs using sub
forms and even a sub sub form in the past with no problems.

My sincere thanks to anyone willing to tackle this problem.

--
Norm Shimmel
Butler, PA

Problem solved! I apologize for the time you spent on trying to help. The
problem was in the Volunteer Number field I had entered into the Main form
header in order to facilitate a name search. Once that field was corrected,
all appeared in order.

Thanks very much for you kind offer of help.
--
Norm Shimmel
Butler, PA


"Baz" wrote:

I maybe stating the obvious here, but have you checked the Link Child Fields
and Link Master Fields properties of your sub form controls? You don't
mention this anywhere.

"NES" wrote in message
...
Using Access 2003 in XP SP2 ...
I have a simple DB consisting of three tables. All three have a common
field
called "Volunteer Number". The primary table is linked to the other two
tables in a one (primary table) -to-many (other tables) relationship.

The data entry form contains a tabbed control consisting of three tabs:
First tab is a continuation of the main form of data that does not need to
remain visible at all times. Second and third tabs are sub forms for each
of
the other tables.

These two are continuous forms that by themselves show proper linkage to
their respective tables and display the Volunteer Number.

The primary form uses a query for it's data -- only because I needed to
add
a single field in the query for "LastName FirstName" to do a record lookup
in
the primary form header.

Once the sub forms were in place I had a very difficult time getting one
of
them to progress with the primary form records, though the other form
worked
fine. I finally deleted the faulty sub form and created a new one with the
wizard using all the default settings. Then it worked. Great!

Then, using a copy of the working DB (I'm getting smarter) I went in and
edited (shortened) the table names and sub form names. I went into each of
the forms' properties and corrected the Data source tables, and they show
the
data in their tables corrrectly. However, now neither of the sub forms are
working properly(progressing with the primary form records) when brought
into
the primary form.

I have tried rebuilding one of them as I did before, but this time it
didn't
correct the problem. I'm at a loss as to why the sub forms are not linking
properly with the primary form. They show up all right -- they just don't
show the data that's already in the linked tables.

I can use the original DB and simply leave it alone if I must. But if
something were to go wrong with that one also, I wouldn't have a clue how
to
fix it because I don't know where the problem lies. It's scary.

Can anyone tell me what I'm doing wrong? BTW, I've tried the old Compact
and repair bit. Also, please note that I've written several DBs using sub
forms and even a sub sub form in the past with no problems.

My sincere thanks to anyone willing to tackle this problem.

--
Norm Shimmel
Butler, PA

No problem, glad you got it fixed.

"NES" wrote in message
...
Problem solved! I apologize for the time you spent on trying to help. The
problem was in the Volunteer Number field I had entered into the Main form
header in order to facilitate a name search. Once that field was
corrected,
all appeared in order.

Thanks very much for you kind offer of help.
--
Norm Shimmel
Butler, PA


"Baz" wrote:

I maybe stating the obvious here, but have you checked the Link Child
Fields
and Link Master Fields properties of your sub form controls? You don't
mention this anywhere.

"NES" wrote in message
...
Using Access 2003 in XP SP2 ...
I have a simple DB consisting of three tables. All three have a common
field
called "Volunteer Number". The primary table is linked to the other
two
tables in a one (primary table) -to-many (other tables) relationship.

The data entry form contains a tabbed control consisting of three tabs:
First tab is a continuation of the main form of data that does not need
to
remain visible at all times. Second and third tabs are sub forms for
each
of
the other tables.

These two are continuous forms that by themselves show proper linkage
to
their respective tables and display the Volunteer Number.

The primary form uses a query for it's data -- only because I needed to
add
a single field in the query for "LastName FirstName" to do a record
lookup
in
the primary form header.

Once the sub forms were in place I had a very difficult time getting
one
of
them to progress with the primary form records, though the other form
worked
fine. I finally deleted the faulty sub form and created a new one with
the
wizard using all the default settings. Then it worked. Great!

Then, using a copy of the working DB (I'm getting smarter) I went in
and
edited (shortened) the table names and sub form names. I went into each
of
the forms' properties and corrected the Data source tables, and they
show
the
data in their tables corrrectly. However, now neither of the sub forms
are
working properly(progressing with the primary form records) when
brought
into
the primary form.

I have tried rebuilding one of them as I did before, but this time it
didn't
correct the problem. I'm at a loss as to why the sub forms are not
linking
properly with the primary form. They show up all right -- they just
don't
show the data that's already in the linked tables.

I can use the original DB and simply leave it alone if I must. But if
something were to go wrong with that one also, I wouldn't have a clue
how
to
fix it because I don't know where the problem lies. It's scary.

Can anyone tell me what I'm doing wrong? BTW, I've tried the old
Compact
and repair bit. Also, please note that I've written several DBs using
sub
forms and even a sub sub form in the past with no problems.

My sincere thanks to anyone willing to tackle this problem.

--
Norm Shimmel
Butler, PA