Continuous Forms - Combo Boxes 1

[suzey]

Hi Everyone,

I have a continuous subform, which has 4 combo boxes across the record.

I currently have the combo boxes querying depending on the previous combo box, and have put the code in the oncurrent, so it does it for each record.

My problem is that I need to display all the records as a continous form, but I can only get the value for the combo boxes to display when the value on the current record relates to the next combo box - did that make sense!

So, when I click onto the first record, it displays all of the values in the combo boxes, but the second and third records do not display the values in the combo box, because the values do not appear in the current records combo boxes. As soon as I click onto the second or third record, it displays the correct information, but does not display the information for the first record.

Anyone got any ideas how I can get round this?

Thanks in advance



Sue

 

[danvlas]

You can't with unbound combo boxes. And if you do it with bound ones, you'll be actually writing to the record...

But I may be wrong (and I really hope so...)




Daniel Vlas
Systems Consultant

 

[suzey]

Daniel,

Thanks for the quick response.

Just to confirm, these combo boxes are bound fields, writing to the record, and it displays the correct information when I click on each individual record, but it will not display all the information for all the records, as the combo box value is different for each record.


Sue

 

[danvlas]

Well, then why do you use the Current event to change them? If they are bound, they will display the correct info as long as their rowsource contains it. This is due to the conditions imposed in the event.
Actually, the information is there, but is not displayed because the row source of the combo box excludes it...

Dan
Daniel Vlas
Systems Consultant

 

[suzey]

Hi Daniel,

Thanks again for your responses, but I seem to have had a flash of inspiration over the weekend, and have sort of got round my problem.

They way I intend to do this is by having 4 unbound combo boxes, shrunk down so the user can only see the pull down arrow and as they select from each one it will put the value into a text box positioned along-side and requery the next combo box.

Sue