Hi Terry,



Basically you are not using the correct object loRodeo as the values. In the For loop you are creating an instance loRodeo for each record in the Me.EventEntriesRodeoBO1 and that is what you have to use, so change your code as follow:

Edhy Rijo

Have you tried moving the Save() method inside the Select/Case statement? I might try something like this:



Select Case EventEntriesRodeoBO1.eventCD

Case "BB"

ContestantsRodeoBO1.Edit()

ContestantsRodeoBO1.EventBB = EventEntriesRodeoBO1.eventCD

ContestantsRodeoBO1.Save()

Case "BR"

etc.



Couple of questions:

Is there a reason that you are checking to see if the Parent BO has moved to the first BO?

Is there only one child BO per parent? If all of the children (assuming one to many) need to be updated, then you may need to iterate them also.



Not sure if this would work...and, I am losing my VB skills. Sorry.

I am trying to iterate thru the parent(evententriesrodeobo1) and update a column in the child(contestantrodeobo1). This code is called from the click of a button on a form. Please note the attached screenshots. The parent child relationship works on the form so what am I missing in the code? I have traced the code and it seems to be doing what I need it to do except the data does not end up in the child in the database?????

I must be brain dead since this seems to be trivial BUT.?????? TIA