connecting two data controls

[jassrs]

Is there a way of connecting two data controls to scroll through two different tables that has data relating to each other...

example:
I have DataEmployeeInfo and DataTrainingInfo
I to tie both together that when the user hits the buttons to navigate through the recordset that they are syncronized... Can anyone help?

 

[Tailgun]

You should be able to use just one data control and use the select statement to join the tables ie inner join, right join or left join.

 

[LostInCode]

The ADO has better events for this, but it is not clear if you are using Dao or Ado.

If Ado, then select the control in the objects left drop-down list of the code window, and the MoveComplete event in the right dropdown list. Then add code there to refresh or filter the second ado contzrol.

With Dao you will find in the same manner a Reposition event.

 

[jassrs]

I am using the DAO.

Can anyone give me any clues to the code. I am at a loss.

 

[LostInCode]

In the code window select from the left drop-down Object list the DataEmployeeInfo and in the right drop-down the Reposition event.

Put your code there to reset the criteria for DataTrainingInfo.Recordsource and Refresh it.

Make sure you check for BOF and EOF on the DataEmployeeInfo.Recordset before attempting to access the fields there.