Tab controls and subforms

[Anderson]

Hi again.

I have set up a form that is separated into 5 tab pages:
site details (info re: location of revenue generated)
revenue details (what, how, etc...)
expense details (info re: linked expenses)
notes
Generating area (identifies the VP responsible for the revenue, program
details and type of revenue)

The Generating area is causing me the issue in question.

This page of the form has an unbound combo box to choose the VP from a list
generated from an imported excel spreadsheet.

There are two option group boxes, one for type of revenue (ancillary or
other) and classification of revenue (goods or service).

Finally, thereis a subform for the program details (Prog_ID - autonumber,
ProgName, and cost centre coding). The issue is that all other pages save
fine, but the information that is entered into the Program Subform does not
get saved in any of the records. I have entered about 30 and none of them
retain the subform data.

Is there something I am missing in terms of referential integrity maybe?
I am at a loss as to what the problem could be, so any help would be great.
I am new to Access so I am sure I might have missed something simple.

Thanks.
Anderson

 

[Anderson]

hhmmm...just thought of this...

Could it be that I have some normalization issues by having so many tabbed
pages to record one record??

Anderson