Bound cascade combo?

[cdoyle]

Well it almost works, but I think this might be the problem with a continous form?
When I make a selection for the first record, all is good.

Go to the next one and when I make a selection from the first combo, the second combo for all the records go blank.

I checked the bound table, and the data is there but the form just doesn't display it after I update?

Any way around this that you know of?

 

[boblarson]

I would say it's time to post your db, if you can. Or, if it is too big to post, email it to me (I can PM you an email address to use).

 

[cdoyle]

I exported my form, and the tables that it uses to this test db.

When you open up the form, make your choices in the first record, and then go to the next record, and make a selection from the first combo. It will erase what you had in second combo of the first record too (it seems to keep the data in the tables tho)

I'm hoping there is a way to prevent this, because this really looks to work the way I need it, besides that little glitch.

 

[boblarson]

I'm working on it. Not sure exactly why it is doing this. It shouldn't and so far I haven't been able to figure out why it is doing what it is doing.

 

[cdoyle]

Did you have any luck with getting this to work on a continuous form?

The only thing I can think of why it's doing this is because all the records all visible on the form. So when it's told to re-query 'combo 2' it does them all since they are all visible?

I hope there is a way around this, and make it update only the active record. It's so close to working just the way I want it!

 

[boblarson]

It's been irritating me as I haven't figured out why it is doing that. I haven't had it do that with my stuff and I'm not sure why it is doing so.

 

[cdoyle]

It's been irritating me as I haven't figured out why it is doing that. I haven't had it do that with my stuff and I'm not sure why it is doing so.

Does the test DB I posted look OK? Don't see any mistakes that I may have made?

 

[cdoyle]

I did some more searching around, and found that the bound field needs to be visible for some reason? It doesn't make sense to me, as to why? but I played around with my testdb, and got it to work.

I wish there was a way around that, since it adds extra room to the form because of the need for the text box.