Iphone

I have a main form with two subforms. The first subform has the child link to the main form identity key.

subform1 - Master Field: SK
Child Field: TrainingMasterSK

The second subform has a master-child link to the first subform.

subform2 - Master Field: subTrainingModule.Form!TrainingModuleTopicSK
Child Field: TrainingModuleTopicSK

All of the links are working and I can see the correct data. I'm able to enter new records on the first subform with no problem.

But when I go to enter a record in the second subform I get the following error message: "The value you entered isn't valid forthis field". This is happening in the BeforeInsert event.

Once I move past the message box then the data in that controls shows up. When I check the table that this subform is using I can see that when a new record is created the TrainingMasterSK field is populated but the TrainingModuleTopicSK field isn't.

The TrainingMasterSK field comes from the main form and the TrainingModuleTopicSK field comes from the first subform. And because the TrainingModuleTopicSK isn't being populated once the record is saved there is no link to the first subform.

I'm under the assumption that the second subform should automatically fill in the TrainingModuleTopicSK field when a new record is entered.

So at this point I have no idea what to do or how to get around this problem. Any help would be appreciated.

Iphone

ok, I added a textbox on subform 2 and set it's value to =[Forms]![TrainingMaster]![txtTrainingModuleTopicSK]

This brings the record number from Subform1 onto the record in subform2. Now you can get rid of the master/child association because that's not going to work.

I think what needs to happen, and correct me if I'm wrong...Once you select a training topic, subform 2 dropdown box should show only the modules associated with that topic? So your subform recordset needs to be refreshed at that time. There is a recordsource associated with that dropdown, but I can't get it to change when I change subform1