Subform driving me mad. HELP ME

[Hiten]

Hi

I posted a topic earlier. I think I am going mad.

Here is what I have done

I have a main table

tbl_EndOfShift

Linked to that main table is many other tables, they are one to many relationships. I have linked them to the main table as a subdatasheet. And build the relationship.

So Now I have

tbl_EndOfShift (Main Table)

And

tbl_SHSummary (Link as one to many)
tbl_FoxOnePatrol (Link as one to many)
tbl_FoxTwoPatrol (Link as one to many)

I have built a form, and the source is tbl_EndOfShift.

I have added the tab control and want to add each of the tables above as subForms, so the user can enter these as they they wish, as they relate to the Unique line in the tbl_EndofShift.

When I use the subForm Wizard it runs me through the link etc and the forms appear fine.

After a while they all revert to the first sub form, in this case tbl_SHSummary.

I have re-built and rebuilt and it keeps on doing it.

What am I doing wrong please help.

Is there another way to do this process

SOMEBODY ADVISE

H

 

[Rich]

What link does Fox One have with EndOfShift ?

 

[Hiten]

FOxONe

Hi Mate

tbl_EndOFShift has one to many relationships with all other tables?

so

tbl_EndOfShift (1 to many) tbl_SHSumarry
tbl_EndOfShift (1 to many) tbl_FoxOnePatrol
tbl_EndOfShift (1 to many) tbl_FoxTwoPatrol

Does that help mate.

Thanks

H

 

[Hiten]

Something else have found out

Something else I have found out that may help.

I have tried again, creating 3 forms.

for the 3 subforms

subFrm_SHSummary
subFrm_FoxOnePatrol
subFrm_FoxTwoPatrol

I am now opening the main form frm_EndOfShift

Opening a Tab Control with 3 tabs for each sub form

Starting Subform wizard and selecting the first subform, in this case

subFrm_SHSummary, all fine I do it again for the other two subforms on the other two tabs.

Save and look at previw, fine. Then out of no where I open again and the last two tabs with

subFrm_FoxOnePatrol
subFrm_FoxTwoPatrol

go white, no form there just subFrm_SHSummary in there.

In Properties the source object has changed from subFrm_FoxOnePatrol to subFrm_SHSumarry and
subFrm_FoxTwoPatrol to subFrm_SHSumarry.

Why has it losts it link.

PLEASE HELP

 

[Hiten]

Something else have found out

Something else I have found out that may help.

I have tried again, creating 3 forms.

for the 3 subforms

subFrm_SHSummary
subFrm_FoxOnePatrol
subFrm_FoxTwoPatrol

I am now opening the main form frm_EndOfShift

Opening a Tab Control with 3 tabs for each sub form

Starting Subform wizard and selecting the first subform, in this case

subFrm_SHSummary, all fine I do it again for the other two subforms on the other two tabs.

Save and look at previw, fine. Then out of no where I open again and the last two tabs with

subFrm_FoxOnePatrol
subFrm_FoxTwoPatrol

go white, no form there just subFrm_SHSummary in there.

In Properties the source object has changed from subFrm_FoxOnePatrol to subFrm_SHSumarry and
subFrm_FoxTwoPatrol to subFrm_SHSumarry.

Why has it losts it link.

PLEASE HELP