Combo Box Display on Form Refresh?

[misscrf]

I have a main form with 2 combos. 1 for Jurisdiction, and 1 for venue. You pick a value for jurisdiction and the venue filters. Jursidiction combo is unbound, and the venue is bound. Everything works good and the values are storing in the table fine. When a user navigates from a record and goes back on the form, the combos don't show the value that they should for that record.

I tried setting the default value of the jurisdiction to be the column(1) of the venue combo (it is the 2nd col. 1st or 0 is the id key that is bound) I also have a requery of the form on navigation next and prev. and I also have requeries of the 2 fields oncurrent of the form. How do I make these combos show the value for that current record as users navigate please?

Thank you.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[adalger]

Requerying an unbound control won't really do anything. If you need the Jurisdiction combo to remember what jurisdiction is associated with a particular record, you'll need to store or be able to reconstruct that information. Another way: with Jurisdiction unbound, it doesn't have a "value for the current record" to show.

TMTOWDI - it's not just for Perl any more

 

[misscrf]

Thank you for responding. Do you know a way to refresh the display of this unbound control though?

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[adalger]

The difficulty isn't in refreshing the display, it's in changing the value to be displayed. You'll need to either store that value in your table and make the control a bound control, or have a way to reconstruct the value and use code in OnCurrent() to set the control to this value.

If I understand correctly what you've done, you may just need to change what you're setting on the jurisdiction combo from the default value to the value itself.

TMTOWDI - it's not just for Perl any more

 

[misscrf]

I fixed this by creating a jurisdiction field to the main form. Now the link is bound and refreshes. Some times the easist answer is right there.

misscrf

It is never too late to become what you could have been ~ George Eliot