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.