Continuous Subform with Combo Boxes

[Lynn_AccessUser]

I have a continuous subform with 2 combo boxes. The value the user chooses in the 1st combo box determines what will show up in the 2nd combo box.

This is working OK. On the current event of the subform and on the after update event on the 1st combo box the 2nd combo box is requeried.

The problem is that the data that is suppose to show in the 2nd combo box (after the user picks a value) doesn't show unless the user is on that record due to the fact that I am hiding the first column in the 2nd combo box by setting the column width to 0. I am binding the 1st column but I want to display the 2nd column.

If I unhide the 1st column all the records in the subform have the correct value showing in the 2nd combo box; however, this is not what I want to display.

For example subform A has 2 records

1. 2004001
2. 2004099

I need to store 2004001 and 2004099 but I only want to display

1. 001
2. 099

If I move the cursor to record 2. then 099 shows in the combo box but record 1. value disappers.

If I move the cursor to record 1. then 001 shows in the combo box but record 2. value disappears.

The data is being stored correctly on the backend, I just can't get it to display on the frontend when I hide the first column.

Hope this made sense . . . sorry if it didn't.

Thanks!!!

 

[Rich]

You have to display the bound column, if you want to display the second column then add an unbound textbox and set its control source to to the second column of your combo

 

[Lynn_AccessUser]

Rich, thanks for the reply.

I had thought about that but didn't want to do that.

Do you know why you can't display the 2nd column.

The 1st combo box (granted it is not dependent on another value) does what it is suppose to. Stores the 1st column value which is hidden but displays the 2nd column.

 

[Rich]

It's one of the limitations with combos and continuous forms, all you can do is make the bound column as small as possible