Kelly, you will two controls in each affected column of the grid, each control is sourced to a different controlsource. You can use the DynamicCurrentControl property of each column to choose which control to display.
Beacuse you are sourcing from two separate tables, there could be issues with refreshing the information in the grid. I would suggest putting the information into a single cursor/view, this will make your life a lot easier.
>I have a need to switch the control source from one row to another with in one column of a grid. What is going on is that I have a table in a relation with two other tables. Depending on a key in the main table I will need the company info from one of the other two tables displayed in a grid. The trick is that it will change from one row to another. Any suggestions?
- Craig
"If you're not prepared to be wrong, you will never come up with anything original."
- Sir Ken Robinson